Combo box show list automatically

[Accessme2]

Hi everyone,
I wonder if there is a way to when On got focus event that the drop down list would display automatically. right now when they start typing the fills automatically but they need to click on the arrow to display all options.
Is there a way to display the list automatically?

Thanks

 

[Kryst51]

Try setting the autoexpand option to yes in the properties for the combo box.

 

[Accessme2]

HI.
Ii have autoexpand= Yes. what this autoexpand do. I would like to when I go the the field to display the list even before I type anything or even if they click the first letter to see the list without have to click on the arrow

 

[Kryst51]

OK, I didn't really understand what auto-expand does. That is not what you want.

Apparently you need to use the "OnEnter" event of the combo box and put the following:

Me.PutTheNameOfYourCOmboBoxHere.Dropdown

Let me know if this works.

 

[Accessme2]

THAT IS IT!!!!

Thank you Kryst51 you are the best!

 

[Kryst51]

You are so very welcome! I am glad it worked.