Showing drop down list while typing 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?

 

[JANR]

In the gotFocus or Keypress event, use:

Me!NameOfCombo.Dropdown

JR

 

[nitinrao]

In the gotFocus or Keypress event, use:



JR

Thanks a lot!!!!

is there a place where I can find these code bits?

 

[JANR]

Intellisence in the VBA code Module gives you the options.

start typing Me!someControlName. when you type the periode a list of possible options pops up.

JR