Re: Command button

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Dirk Goldgar (dg_at_NOdataSPAMgnostics.com)
Date: 07/06/04 

Date: Tue, 6 Jul 2004 14:37:53 -0400

"Lexi" <anonymous@discussions.microsoft.com> wrote in message
news:2818101c46385$65108c40$a301280a@phx.gbl
> 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)
Quantcast