Option Button Help Needed Please

[specious]

Could someone please help me figure this one out?
I have an Access form with a option group containing five check boxes. When one of the boxes is selected and a button is pressed, I would like to run a specific report depending on which button is pressed. Can anyone give me some insight on where I should start?

Thanks in advance.

 

[Databaseguy]

Let's assume your option group is called optChooseReport

Private SomeCommandButton_OnClick()
Select Case me.optChooseReport
Case 1
docmd.openreport "Your Report"
Case 2
docmd.openreport "Your Other Report"
Case 3
'etc etc
Case Else
msgbox "Please choose something"
End Select
End Sub
Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy

 

[specious]

Thanks for you help so far, just one questions. How do I know which check box is selected and which corresponding report to run?

 

[Databaseguy]

Right click the check boxes and look at their properties. Each one has an Option Value Property. You can accept the default values assigned by Access, or enter your own (being careful not to duplicate).

Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy

 

[specious]

Thanks, I think it is working the way we need it to.