Hi Jeffrey.

>> To me this suggests a grid but the problem is that they need to see so much info about each job (including the 20 trucks assigned) while displaying as many jobs as possible on the form that it needs display more than one row per record. <<

You don't say how your data is structured, but if you have a job master in one table and job info in related tables, you could create a parameterized view for job info on Job number and display the information in a parent grid (jobs) and a child grid (job info). Requery() the RecordSource of the child grid in AfterRowColChange of the parent.

Marcia