Showing drop down list while entering data in a field

[nitinrao]

Hi everyone!

I have a form with a field that has a drop down menu (which links back to a field in another table). When entering data in this field, the user can either select data from the drop down menu or manually type it (and of course there is an error when the entered name is not part of the drop down menu). However, I want to make it so that when a user manually types data into the field, he also sees the drop down menu show up. More specifically, I want to enter a code that reveals the drop down menu (even while typing in the field) on the "On Key Press" event.
what would my code be?

[pbaldy]

I typically do it in the got focus event, but the code would be:

Me.ComboName.Dropdown

[llkhoutx]

You can also change the number of rows displayed by changing the "List Rows" property of the combo box, the default number of rows is 8.