Radio Buttons Used to Open Reports- Option Group 1

[gabriellec]

I do not understand the total concept of getting VBA to look at what radio button (in an option group) the user clicked to get certain reports to open.

I understand that in an option group allows the user to select only one of the buttons. I also understand that Access puts a numeric value to each button (i.e. 1,2,3...). But I am not quite sure how to write the Select Case statement to open specific report when they pick that button.

Access 97

Thnx

 

[Maquis]

You use the "option value" property of the buttons to determine which one a user clicked. For example, if you have an option group called "Type" and 5 buttons, you can set the option value of the 1st button to 1, 2nd button to 2, etc...

Then you write a case statement to evaluate the buttons like so:

Select Case Me![Type]
Case 1
<do stuff>
Case 2
<do stuff>
Case 3
<do stuff>
Case 4
<do stuff>
Case 5
<do stuff>
Case else
msgbox &quot;Did you press a button??&quot;
End Select

 

[gabriellec]

Do I put the Select Case statement into the Click event for the option group?

 

[Maquis]

Depends on what you want to do. If you want to open up reports or other forms, then create a command button called &quot;process&quot; or something like that and put this code in the click event of the command button.

 

[jazzz]

On an option button group you would make the select case afterupdate.

 

[gabriellec]

It is working great. Thanks!