Multiple Reports

[SSG Araujo]

I am looking to print multiple reports using a single critera. In otherwords when I press a button I want a box to come up and ask me for certain critera and based on my input I want the database to execute a print preview on multiple reports using the critera enter.

 

[Joe Fallon]

Use a form and a button.
Add a texbox to the form.
This will be your criteria.

Change the queries to point to this form and textbox:
Criteria:
Forms![TheForm]![txtCrit]

Behind the button just use
DoCmd.OpenReport "Report #1"
DoCmd.OpenReport "Report #2"
DoCmd.OpenReport "Report #3"
--
Joe Fallon
Access MVP

I am looking to print multiple reports using a single critera. In

otherwords when I press a button I want a box to come up and ask me for
certain critera and based on my input I want the database to execute a print
preview on multiple reports using the critera enter.