Print 3 reports

[CAM]

I like to have a command button in my form that will print out three
different reports - "AnnualReport", "MonthReport", and "BudgetReport"
automatically without reviewing the reports. All I want to do is to just
print out the report. How do I do that? I am using Access 2002. Any tips
will be appreicated. Thank you.

Cheers

 

[Wayne-I-M]

DoCmd.OpenReport "AnnualReport", acViewNormal, "", "", acNormal
DoCmd.OpenReport "MonthReport", acViewNormal, "", "", acNormal
DoCmd.OpenReport "BudgetReport", acViewNormal, "", "", acNormal


Create a button on your form (in design view).
Right click the button and open the properties box
In the "Event" column select the OnClick row
Right click and select slect build (code) option (...)
Put the code above in between the 2 lines of code that are already there so
it looks like this

Private Sub ButtonName_Click()
DoCmd.OpenReport "AnnualReport", acViewNormal, "", "", acNormal
DoCmd.OpenReport "MonthReport", acViewNormal, "", "", acNormal
DoCmd.OpenReport "BudgetReport", acViewNormal, "", "", acNormal
End Sub


Of course the "ButtonName" will be different in your code.

Good luck