Radio Button Group selection in Access 1

[rhaven]

I have a group of 3 radio buttons and I need to use a command button to open a report depending on the particular radio button is selected.
How do I make out which radio button in the group is selected in my If statement.
I figure its an easy question but I've been breaking my back over it for 2 days. I need some help real quick.
Thanks.

 

[jebry]

Hi!

Assuming the radio buttons are in an option group, then the option group's value will be the option value of the selected radio button. The option value are automatically set at 1, 2, 3 etc. but can be edited.

hth Jeff Bridgham
bridgham@purdue.edu

 

[rhaven]

Thanks for the quick response Jebry,
Yes, the radio buttons are in an option group and have the OptionValue property as 1,2 and 3 resp.
But that property is set and doesn't change even when the option buttons are selected individually by the user.
I'm still stumped what property do I check for each option button to see if IT is the one that has been selected.

 

[jebry]

Hi!

Select Case YourOptionGroup.Value
Case 1
Open report for first button
Case 2
Open report for second button
etc.
End Select

hth
Jeff Bridgham
bridgham@purdue.edu

 

[rhaven]

Thanks a lot Jerby. It works fine. I had the option group as a frame. All I had to do was check for Frame.value=option Value (ie: 1,2 3)
Your first email helped me figure it out.
Thank you for your prompt replies. I never used online help before and I'm very happy to see people helping each other out.