Print two report at a time

  • Thread starter Thread starter CAM
  • Start date Start date
C

CAM

Hello,

I am using ms access 2003 and I want to print two different reports via a
command button.
The first report is called "Summary" and the second report is called
"Detail"

Cheers
 
This is very easy and there are two ways to do it.

1) Create a Macro named mcPrintDetSum in there put an OpenReport command for
each report you want in the order you want it printed out.
Have the button_click sub run a DoCmd.RunMacro mcPrintDetSum

2) Don't create the Macro, simply type in the cmdbutton_click sub
DoCmd.OpenReport "Details"
DoCmd.OpenReport "Summary"
Place them in the order you want them to be printed out.

You can also create filters and additional where clauses from each instance.

geoleo68
 
Thanks for the tip.

geoleo68 said:
This is very easy and there are two ways to do it.

1) Create a Macro named mcPrintDetSum in there put an OpenReport command
for
each report you want in the order you want it printed out.
Have the button_click sub run a DoCmd.RunMacro mcPrintDetSum

2) Don't create the Macro, simply type in the cmdbutton_click sub
DoCmd.OpenReport "Details"
DoCmd.OpenReport "Summary"
Place them in the order you want them to be printed out.

You can also create filters and additional where clauses from each
instance.

geoleo68
Click to expand...
 
Back
Top