MS Access VBA - Disable object while on focus

[Ronald_yoh]

Does anyone know how to disable the object in MS Access via VBA while the object is on focus.

Suppose you have a "save" button, when you click the button and at the end of the execution line (before exit sub), you want to disable the "save" button.

I got an error of doing the above since the object is still on focus.

Any thoughts???

Thanks
R

[Carl A]

Set Focus to another control just before you disable the Save Button

[Ronald_yoh]

mate.. ur comment seriously not helping at all!!!

[Carl A]

Suppose you have a "save" button, when you click the button and at the end of the execution line (before exit sub), you want to disable the "save" button.

Private Sub cmdSave_Click()
cmdOK.SetFocus 'or another control
cmdSave.Enabled = False
End Sub

[Ronald_yoh]

I had tried the logic but it never passes the focus to another control/object.

Any other solutions, mate?

Cheers
R

[Carl A]

AFAIK there isn't any other way to disable a control in access as long as it has the focus. There are alot of other resources on the net that will tell you the same thing.
Here is a working example.