VB Code for Drop Down List

[Such a Beginner]

How do I create code that will enable me to hit enter on an item in an
Unbound Combo box drop down list, such that when I hit enter on that
particular item, it opens the related form?

Thus far, I've tried If ... Then ... Else statements, with 'DoCmd.OpenForm
"...", acNormal' actions, only to have the first action statement function
vs. the appropriate action statement for the Unbound = Item # from the drop
down list.

 

[Golfinray]

How do I create code that will enable me to hit enter on an item in an
Unbound Combo box drop down list, such that when I hit enter on that
particular item, it opens the related form?

Thus far, I've tried If ... Then ... Else statements, with 'DoCmd.OpenForm
"...", acNormal' actions, only to have the first action statement function
vs. the appropriate action statement for the Unbound = Item # from the drop
down list.

 

[Larry Linson]

How do I create code that will enable me to hit enter on an item in an
Unbound Combo box drop down list, such that when I hit enter on that
particular item, it opens the related form?

Thus far, I've tried If ... Then ... Else statements, with 'DoCmd.OpenForm
"...", acNormal' actions, only to have the first action statement function
vs. the appropriate action statement for the Unbound = Item # from the drop
down list.

You don't indicate that you included a WhereCondition clause using the
selected value from the Combo. Read carefully the Help for DoCmd.OpenForm.
If you, then, can't make it work, post back here with specifics of what you
did... not just a single quoted instruction with ellipsis.

Larry Linson
Microsoft Office Access MVP