Solved: Disabling a command button

[Rockn]

I want to disable a command button after an event is fired.

The button fires of a RunSQL event, sets a value in a table to not show the button and then I tried to have it set Me!ControlName.Enabled = False, but it will not let me because the control still has focus. Is there a way to remove the focus and then set the control to disabled? I was thinking of setting the focust to another control and then disabling it.

 

[OBP]

Rockn, you should be able to do it as you have outlined by setting the "Focus" to another control.
If you do not have a "Control" on the same form as the Command Button then I usually use a text box, it can't be set to "Invisible", but it can be set to a very small size.

 

[Rockn]

I set the focus to another control after the button is clicked and it worked like a charm.

 

[Zack Barresse]

You should be able to also take a look at the ActionControl property. If this is a controls toolbox (ActiveX) control, you should be able to also return the focus to the worksheet, enabling you access to disable the control.

 

[Rockn]

This is in Access and I am not using any AX controls.