Multiple report

  • Thread starter Thread starter Sanjay BAnsal
  • Start date Start date
Or . .. If you are only wanting to preview one at a time you will need for
eg. to add an option frame to your form so that the user can chose which
report they want to view and then on the OnClick event of the command button
add the code

Select Case ReportType
Case 1
DoCmd.OpenReport "Report1", acViewPreview
Case 2
DoCmd.OpenReport "Report2", acViewPreview
Case 3
DoCmd.OpenReport "Report3", acViewPreview
End Select

HTH
Al
 
Back
Top