Hiding a control in focus on click of another control in ms access 2007?

[HiGu]

I have a combobox and also a label on the same form.On click of the label, the combobox is to be made invisible.the problem is if the combobox is in focus and the label is clicked, it throws error saying that You can't hide a control which is in focus.I tried setting focus on the label itself when it is clicked but it didn't work.I also tried putting this code I found in one of the discussion forum

Sendkeys"{TAB}"
DoEvents

it didn't work.
Also tried the following without any result

Screen.ActiveControl.Name=label1

[Mihail]

Move the focus to the form itself before hide the combo box:

me.SetFocus

[HiGu]

Again: didn't work
same error

[TheSmileyCoder]

You need a visible, enabled textbox (or combo/listbox) to move focus too, before hiding the combobox.

You cannot set focus to a label.

[HiGu]

Oh. Thanks.I found the similar answer on the site of "msdn" but I was skeptical about it as it wasn't mentioned explicitly.

[NeoPa]

HiGu:
I found the similar answer on the site of "msdn".

Indeed. It's always a good idea to search for an answer before posting a question. We're happy to answer your questions, but it will save you a lot of time and energy. Also, the more you do that the better able you are to find the best answers.