make dropdown disappear

[robart6]

Help, please!

When my second form opens, the combo box dropdown from the first form is visible. How can I make the dropdown disappear?

 

[Rusty]

Is the second form a subform, i.e. part of the first form, or are they both separate forms?

Bit more detail please

 

[robart6]

Separate forms.

 

[Johny]

Why do ya want to hide the combobox on the first form?

 

[robart6]

Johny, the dropdown on the first form is working fine. The problem is the first form's dropdown appears on the second form when the second form opens.

 

[smercer]

Johny, the dropdown on the first form is working fine. The problem is the first form's dropdown appears on the second form when the second form opens.

In the OnOpen event of the second form insert line

the form name is "First_Form"

Form_First_Form!cbo_My_Drop_Down.Visible = False

you need to insert the word and the underscore "Form_" in the begining of the form reference.

Does this help? Please respond

 

[robart6]

smercer, thanks for the reply. Somehow the problem resolved itself. Not sure if it just went away or if I changed something to make it go away.

 

[smercer]

smercer, thanks for the reply. Somehow the problem resolved itself. Not sure if it just went away or if I changed something to make it go away.

Thats because it is microsoft. they like to have an error here and there so you would spend money to have it fixed.

when I first started using VBA i deleted the onerror gotos that the wizard put in and problem went away.

 

[Mile-O]

It may just have been a loading or repainting issue.