allowing or disallowing changing the state of check box

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
 
A

alekm

One addition:
The problem occurs (repeating) when Cancel = True was applied previosly.
 
J

Jeanette Cunningham

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
 
A

Amy E. Baggott

Or you could disable it when the form is opened using the form's On Open or
On Current event. Use the same code.
 
Top