troubleshoot option group

  • Thread starter Thread starter angie
  • Start date Start date
A

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?
 
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?
Click to expand...

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.
 
Back
Top