Combo box dropdown property not working

B

boomer

From a previous post I found this information:

In the GotFocus event, you should need one line of code.

Private Sub Combo6_GotFocus()
Me.Combo6.Dropdown

End Sub

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
...
--

I am using Access 2007. When I open a form I want the customer combo box to
automatically open. The focus immediately goes to the combo box but it does
not open unless I click on it or press F4. The code I am using is as follows
in the "On Got Focus" event of the combo box:
Me.cboPickCustomer.dropdown

Can anyone help me with this problem?

Thanks

Boomer
 
P

pietlinden

From a previous post I found this information:

In the GotFocus event, you should need one line of code.

Private Sub Combo6_GotFocus()
   Me.Combo6.Dropdown

End Sub

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
--

I am using Access 2007.  When I open a form I want the customer combo box to
automatically open.  The focus immediately goes to the combo box but it does
not open unless I click on it or press F4.  The code I am using is as follows
in the "On Got Focus" event of the combo box:
Me.cboPickCustomer.dropdown

Can anyone help me with this problem?

Thanks

Boomer

well then why not put it in the form load event?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top