Printing Reports through a Form

[Guest]

I have a form in Access 2002 that is used to generate three different reports
for a sales program. These reports are generated for about 30 different
offices.

In the form, I can select a specific office from a drop down menu and then
click on the button of the report I wish to generate. This will open that
report and I can print all of the records it generates. I must then close
the report and repeat the steps for the two remaining reports, and then for
the rest of the offices.

What I would like to be able to do is select the office from the drop down
menu and then select a button on the same form that will print all three
reports at the same time. Is this possible and how would I do that?

 

[Allen Browne]

Yes. You can use the OpenReport action 3 times in the Click event of your
button, so it prints the 3 reports.

Are you using a macro or code to handle the button click?
Just add 2 more lines to the macro (OpenReport action), or to the code
(OpenReport method.)

 

[Guest]

Thank you! This was very helpful!!

I used the OpenReport "PrintOut" line to print the documents, but it now
prints the blank reports, is there a way to keep it from doing this?

 

[Allen Browne]

I'm not clear what's happening here.

Did you use a macro? Or code?

Did you use OpenReport? Or PrintOut? Or both?