troubleshoot option group

[angie]

i have an option group with two check boxes. if option 1 is checked nothing
needs to be done, if option 2 is checked i want to open another form and
minimize the current form. i have created an openform macro but it doesn't
work no matter where i put it!

could you help me?

 

[fredg]

i have an option group with two check boxes. if option 1 is checked nothing
needs to be done, if option 2 is checked i want to open another form and
minimize the current form. i have created an openform macro but it doesn't
work no matter where i put it!

could you help me?

The usual values of the options in an option group are 1, 2, 3, etc.
Why check boxes as options instead of the usual radio buttons?

The OptionGroup takes it's value from whichever button (or check box)
has been clicked. So, if there are just the 2 choices, you could code
the OptionGroup's AfterUpdate event:

If Me.OptionGroupName = 2 then
DoCmd.Minimize
DoCmd.OpenForm "FormName"

End If

This will open the other form, and minimize this form.