How do I disable a command button after it is clicked?

[irunergoiam]

I've got a command button that I would like to disable after it is clicked. Any ideas how I can do this and where I should put the code? I'm thinking it would go in the On Click event.

Thanks much for any feedback from the forum!

 

[John Big Booty]

You could add the following to the end of buttons On Click event;

Me.Enabled = False
Me.Locked = True

Of course you will have to reveres both those settings at some stage when you wish to re-enable the button.

 

[Mr. B]

If you try to disable or lock a control that has the focus you will get an error message.

Before using either of the codes provided above by Big John Booty, be sure you set focus to another object, like another control.

Me.NameOfOtherObject.SetFocus

 

[John Big Booty]

If you try to disable or lock a control that has the focus you will get an error message.

Before using either of the codes provided above by Big John Booty, be sure you set focus to another object, like another control.

Me.NameOfOtherObject.SetFocus

Oh yes I forgot to mention that, thanks Mr. B

 

[Mr. B]

No problem. I have been bitten by that one way to many times.

 

[irunergoiam]

Thanks to you both. Setting the focus is the piece that I was missing.

Cheers...