allowing or disallowing changing the state of check box

  • Thread starter Thread starter alekm
  • Start date Start date
A

alekm

Hi,
what's the best moment to check if the user has right to change the state of
check box and then to allow it or cancel it. I've tried with "before update"
event procedure. It seems to work but after, when I press anything else on
the form event procedure is repeating?
Any help?
thanx

alekmil
 
Try using the enter event of the checkbox to check if user has right to
change to checkbox.

If you don't want user to change the textbox, lock the textbox.

Me.TextboxName.Locked = True

If it's OK for the user to change the textbox, unlock it.
Me.TextboxName.Locked = False

Note: replace my object names with your names.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 
Or you could disable it when the form is opened using the form's On Open or
On Current event. Use the same code.
 
Back
Top