If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
VB Code for 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. |
#3
|
|||
|
|||
VB Code for 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 |
Thread Tools | |
Display Modes | |
|
|