VB Code for Drop Down List

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.

On the after update of the combo type docmd.openform [myform],,,

"Such a Beginner" wrote:

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.

"Such a Beginner" wrote

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