Disable a button

[Tony Wainwright]

I have a form that is used to import data. There are 2 buttons and a
label - cmdImport, cmdClose and lblStatus. When I click the Import button I
want to disable both buttons so that the user can't click anything else
while the import routine is running. If I put Me.cmdImport.Enabled = False
in the ClickEvent, I get an error saying that I can't disable a button while
it has the focus. Is there anyway to get round this?

Tony

 

[Brendan Reynolds]

You need to set the focus to a control that will not be disabled, but that
control does not need to be visible. Add a command button with no code, set
its Visible property to False, and set the focus to that command button
before disabling the other controls.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.