Combo box dropdown

[Dale Fye]

I've got an application that I originally programed the
Got_Focus event of a bunch of combo boxes to dropdown the
combo.

My client wants to minimize use of the mouse during data
entry in this application, and would prefer to be able to
tab into the combo and type. However, they have indicated
that they would like to be able to use the down arrow to
dropdown the combo, and select from the list.

I've removed the code from the got_focus event, and added
some code in the controls keydown event to dropdown the
combo if the keycode = 40 then dropdown the list. The
wierd thing is that if I have an item selected, then hit
the down arrow, it drops down the list and moves to the
second entry below the currently selected item. Then,
sometimes, the selected item will move to another
selection without any further input from me. What I think
I need is a way, during the keydown event of the combo
box, to determine whether the box is already dropped
down. Anyone know if there is a way to do this?

 

[Wayne Morgan]

You may just want to use the built in Alt+DownArrow to drop down the box.
Yes, it is possible to determine the state of the drop down.

http://www.mvps.org/access/api/api0052.htm

 

[Dale Fye]

Thanks, Wayne.

Been using Access for 7 years and didn't know about the
Alt functionality with the combo.

 

[Bob]

I have the same situation, where my data entry people do
not want to select the down arrow key to open the combo
box. Is there an example of how I can do this? Can I use
a macro to accomblish this?

 

[Wayne Morgan]

In the Got Focus event of the combo box you can use code such as this to
open the list.

Me.cboComboBoxName.DropDown