Combo Box to open form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to have a combo box that has 3 selections on one form open
another form based on what is in the combo box? Specifically what I have is
a form that has a combo box with the values high, Medium, and low. If the
user selects "high" I want a new form (the "high" form) to open so that the
user can see the data there. If the select "medium" I want the medium form to
open, and so on. Is this possible? TIA!
 
Try this code on the OnClick event of the button that used to open the form

Docmd.OpenForm Me.[ComboName]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Opening Second Form 5
Combo Box 3
combo box filter 1
Combo Box and First Record 5
Coerce Combo Box Based On Invidible Column 0? 2
Combo Box Question 4
Cascading Dependant combo boxes 0
Combo box to control two sub forms 2

Back
Top