notreconised
Technical User
is it possible to launch a form from a combo box
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Forms
- Thread starter notreconised
- Start date
- Status
Very basic information....in future please provide more details.
Assumption: ComboBox lists forms you want to open. After selecting a form, you want the form to open.
1st Suggestion: Don't use the combobox to open the form. This will be difficult for the user. Use the combo box to select the form to open and use a button to open the form.
In the AfterUpdate event for button (or combobox if you really want to use it), double click the box and Event Procedure should appear. Click the build button (3 dots ...) at the end of the field. In the window that pops up (code window), put:
DoCmd.OpenForm Me![Name of combo box here] Please remember to give helpful posts the stars they deserve! This makes the post more visible to others in need!![[thumbsup2]](/data/assets/smilies/thumbsup2.gif "[thumbsup2] [thumbsup2]")
Robert L. Johnson III, A+, Network+, MCP
Access Developer/Programmer
robert.l.johnson.iii@citigroup.com
Assumption: ComboBox lists forms you want to open. After selecting a form, you want the form to open.
1st Suggestion: Don't use the combobox to open the form. This will be difficult for the user. Use the combo box to select the form to open and use a button to open the form.
In the AfterUpdate event for button (or combobox if you really want to use it), double click the box and Event Procedure should appear. Click the build button (3 dots ...) at the end of the field. In the window that pops up (code window), put:
DoCmd.OpenForm Me![Name of combo box here] Please remember to give helpful posts the stars they deserve! This makes the post more visible to others in need!
Robert L. Johnson III, A+, Network+, MCP
Access Developer/Programmer
robert.l.johnson.iii@citigroup.com
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question