resetting option button

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an option button on a form. When it gets selected by the mouse a
little green dot appears in it and a macro is executed.
After the macro is run and the program returns to the form I want to clear
the little green dot in the option button.
 
Simcon,

When an option button is selected, its value is True (or -1), when it is not
selected, the value is False (0).

The simplest way is to set it to False in the AfterUpdate event procedure:

DoCmd.RunMacro "YourMacro"
Me![YourOptionButton] = False

Hope that helps.

Sprinks
 
Back
Top