Print Three Forms with one Control. 1

[egptech]

I have three reports that I print out after each piece of equipment is set up. All three reports are based on the same qry. I am just starting to learn some VBA and was wondering if there is a way to create one control that will run all three reports with the option of viewing them then printing them. I am open to suggestions and very grateful for any assistance.
Gene

 

[THWatson]

Gene
I assume you are doing this from a form.

In your form, put a Command Button, but don't use the wizard.

Enter the following code in the Click property for the command button...
DoCmd.OpenReport "Report1Name", acViewPreview
DoCmd.OpenReport "Report2Name", acViewPreview
DoCmd.OpenReport "Report2Name", acViewPreview

All 3 reports will pull up. You can view them one at a time by minimizing the one that is on top, print the one that is in view at the moment, whatever.

Tom

 

[egptech]

Thanks,

It was another case of looking so hard for the difficult answer that I totally overlooked the easy one.

Thanks again,
Gene