How do I link several option buttons to several reports?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to see a different report when I click on the different option
buttons?
 
Use the After Update event of the option group. Each option button will
have an option value. The value of the option group will be which ever
button was clicked. Then you use a Select Case statement to open the
report:

Private Sub opgRptSelect_AfterUpdate()
Dim strRptName As String

Select Case Me.optRptSelect
Case 1
strRptName = "SillyNonsenseReport"
Case 2
strRptName = "UselessInfoReport"
Case 3
strRptName = "ConfusingDataReport"
End Select

Docmd.Openreport strRptName
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2010 Report Button 0
Printing Report for one a single record - Several problems 5
Oversensitive touchpad on modern laptops 0
How to remove stuff that appears when I click on the windows button on the bottom left of my screen? 2
Access Access Report Works on One Machine but not Another 3
Store info for reports from switchboard 1
Print report help 11
Can't create a report from my query in Access 1

Back
Top