option group

[jeff]

I am trying to get 3 option buttons to open 1 macro which
has conditions for running different from openings. Each
depending on which button is selected. The option values
are set to 1, 2 3. I do not know how to format the
condition for the macro. It is located on a form and only
one option group with three buttons. If option button 1
is selected then it satisfies the first condition =1 and
so on. I keep getting a type mismatch error with the
following format.

[Forms]![MAIN MENU]![Option16]=1

Please help!

 

[JohnR]

Assuming the Option16 is the Option Group Frame that
contains the three option buttons then:

For the Click event of the Option Group
Select Case Option16
Case 1
Do This
Case 2
Do This
Case 3
Do This
Case Else
Error Trapping
End Select