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

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

"alekm" wrote:

> 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

"alekm" <(E-Mail Removed)> wrote in message
news:A5BC3CEA-2E00-4820-A127-(E-Mail Removed)...
> One addition:
> The problem occurs (repeating) when Cancel = True was applied previosly.
>
> "alekm" wrote:
>
>> 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

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

"I''m going crazy and I''m taking all of you with me!" -- Linda Grayson


"Jeanette Cunningham" wrote:

> 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
>
> "alekm" <(E-Mail Removed)> wrote in message
> news:A5BC3CEA-2E00-4820-A127-(E-Mail Removed)...
> > One addition:
> > The problem occurs (repeating) when Cancel = True was applied previosly.
> >
> > "alekm" wrote:
> >
> >> 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
>
>
> .
>