I have a training database that tracks employee training.

I have 7 locations and about 120 employees. I set up a seperate query to build a report for each location which was pretty easy.

What I would like to do now is design a report to list an individual employee training report without building 120 queries.

My Query fields are NAME, COURSE, DATE, CREDITS.

I want to be able to select a name to generate a report, instead of building 120 queries. (sorry for being redundent)

Add a list box to a form with rowsource as the persons ID and name, set the bound column to reference the primary key(unique record identifier).

Now, build your query including all field you want shown in the report. In the criteria under the unique record identfier field right click and choose build - select forms from the tree and the from the list presented select the form with the list on it. The second column of the expression builder will present all controls on that form - double click the listbox control, you will get a reference like:

Forms![MyForm]![MyListBox]

Now when you run the query from the listbxo form after selecting a person the query will reference the listbox's bound column and use that as criteria.

Thanks!

That got me started, building the report was a bit more, but within my capabilities. This stuff is fun!