Picking and choosing what reports to print from a list.

S

Srowe

I want to be able to have a list of all of my reports on one form and have
the user be able to choose which one (s) they would like to print. It would
be based on a query of what file number the reports are to come from.

Thanks.
 
T

Tom van Stiphout

On Mon, 17 Nov 2008 18:58:01 -0800, Srowe

One option is to have a multi-select listbox and set its rowsource to
a query on the system table MSysObjects.
Then write some VBA code to loop over the selected items and call each
report in sequence, with the WhereClause argument set to the file
number you want to run it for.

I would be surprised if ALL your reports would be about file numbers.

-Tom.
Microsoft Access MVP
 
Top