Printing out 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

 

[fredg]

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

Code the Click event of a Command Button:
DoCmd.OpenReport "AnnualReport"
DoCmd.OpenReport "MonthReport"
DoCmd.OpenReport "BudgetReport"

 

[Jim Bunton]

In Access 2000 it will be something like

Private Sub MyRptCmdButton_Click()
On Error GoTo Err_MyRptCmdButton_Click

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

Exit_MyRptCmdButton_Click:
Exit Sub

Err_MyRptCmdButton_Click:
MsgBox Err.Description
Resume Exit_MyRptCmdButton_Click

End Sub


have a look at help on OpenReport Method - the feature of being able to use
a where condition is often quite useful

Jim Bunton


end sub