Command button

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

"Lexi" wrote in message

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

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.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)