Option group

[DEX]

How do you reference an option button in an option group
on a form. I'd like to write a select case statement to
have actions performed if a certain button is selected.

thanks

 

[Jeff Boyce]

The option group's value is the value of the option "button" selected.
Check the option buttons for the values (typically 1, 2, ...).

In your case statement, use something like (actual syntax may vary):

Select Case optMyOptionGroup
Case 1 'the option button with value = 1 was selected
blah, blah, blah
Case 2 ' option button value=2
...

Good luck

Jeff Boyce
<Access MVP>