Reports to print

[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?

 

[Fredg]

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

 

[Mark]

Hi,
You could also use the Switchboard to select the report
format that you want to be presented.
m.