Reports to print

  • Thread starter Thread starter G. Vergara
  • Start date Start date
G

G. Vergara

I've created a form that has data for four different
reports. The data are the same for the reports, but they
are presented in different ways. How do I create a yes/no
check box to select which reports to print?
 
1) For 4 different reports you could add an Option Group to the form.
Then code the Option Group AfterUpdate event:

Dim strReport as String
Select Case OptionGroupName
Case is = 1
strReport = "Report1"
Case is = 2
strReport = "Report2"
Case is = 3
strReport = "Report3"
Case Else
strReport = "Report4"
End Case
DoCmd.OpenReport strReport, acViewPreview

2) You can also use a Combo Box with the names of the reports.
Then code the Combo Box After Update event:
DoCmd.OpenReport Me!ComboName, acViewPreview
 
Hi,
You could also use the Switchboard to select the report
format that you want to be presented.
m.
 
Back
Top