Force the dropdown list to display on Combo Box

[DB2010MN26]

I have a combobox which has a row source of a table which lists my clients as well as thier client id. When I type in the combobox, it auto completes to the nearest possible match of client. I'm fine with it functioning this way, however I have to click the down arror to the right of the box in order to get it to display the row list of possible clients in my table.

I would like to have this dropdown list display permanately so that when I open the form, the drop down list always displays. How do I go about doing this?, I can't seem to find anything in the property sheet.

[pbaldy]

You want it dropped down whether the combo has focus or not? I don't think you can. Perhaps you want a listbox instead of a combo.

[DB2010MN26]

When I try to create a listbox though, it will only index to the first letter. So for example, if I type the letter F it scroll down to last names with F, but then if I type I, it will go back up to records that start with I.

The combo box lets me search directly. Can this be enabled with a listbox?

[pbaldy]

To my knowledge you can't type into a listbox, so I suspect you're stuck with a combo. I don't think you can leave it dropped down if it doesn't have focus, but you can drop it down automatically when it gets focus with:

Me.ComboName.DropDown

in the got focus event.

[DB2010MN26]

That code worked great, I also set for the after update event as well.

Thanks!

[pbaldy]

No problem!