Multiple Reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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



SSG Araujo said:
I am looking to print multiple reports using a single critera. In
Click to expand...
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.
 
Back
Top