Printing two reports individually from same prind cmd button.

[oriongate]

Hello,
I was wanderindering if it is possible to print two or more reports individually from the same cmd button. If yes, I would really apreciate if someone could suggest a basic vb code for it. My form is becoming very cluttered and a solution like the one above would certainly solve that problem for me.
Thanks.oriongate

[pbaldy]

In the immortal words of Nike, just do it:

DoCmd.OpenReport "FirstReportName"
DoCmd.OpenReport "SecondReportName"

[June7]

Is it cluttered because you have a button for each report to print? Do you still want to offer users ability to pick and choose which to print? Instead of buttons, use a listbox that offers the reports to print then use AfterUpdate event of listbox to print the selected item. If the report name is exactly replicated in the listbox, simply:

DoCmd.OpenReport Me.listboxname