Tickbox problem

  • Thread starter Thread starter Tony Williams
  • Start date Start date
T

Tony Williams

I have a series of tickbox controls on a form. When the user clicks on them
a form is opened, I used the onclick event to do this. However if the user
clicks the tickbox in error the form will open and then if they unlick it if
they have clicked in error the form opens again. Is there anyway that I can
stop the form opening on unclick?
 
Tony Williams said:
I have a series of tickbox controls on a form. When the user clicks on them
a form is opened, I used the onclick event to do this. However if the user
clicks the tickbox in error the form will open and then if they unlick it if
they have clicked in error the form opens again. Is there anyway that I can
stop the form opening on unclick?
Click to expand...

Use AfterUpdate instead and test the value of the CheckBox to decide if the form
should be open.
 
Thanks Rick worked just fine
Tony
Rick Brandt said:
If you only want to open the form when they toggle the CheckBox from False to
True then you need to test the state of the CheckBox after it has been changed.


If Me!CheckBoxName = True Then DoCmd.OpenForm...
Click to expand...
 
Back
Top