Command button

L

Lexi

I have a command button in my form. Is there any way to
restrict users to only clicking this once in any form
instance? e.g. it will not let them click it again if
they have already clicked it once and had it perform its
action.

Lexi
 
D

Dirk Goldgar

Lexi said:
I have a command button in my form. Is there any way to
restrict users to only clicking this once in any form
instance? e.g. it will not let them click it again if
they have already clicked it once and had it perform its
action.

Lexi
Click to expand...

As part of its Click event procedure, put code like this:

Me!SomeOtherControl.SetFocus
Me!YourCommandButton.Enabled = False

where "SomeOtherControl" is the name of some other control on the form
that is capable of receiving the focus, and "YourCommandButton" is the
name of the command button you want to disable.
 
Top