allowing or disallowing changing the state of check box

[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

 

[alekm]

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

 

[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

 

[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.