Combo Box to open form

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!
 
G

Guest

Try this code on the OnClick event of the button that used to open the form

Docmd.OpenForm Me.[ComboName]
 

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

Combo Box 3
Opening Second Form 5
Combo Box and First Record 5
combo box filter 1
Access 2003: text on form but store numerically 2
Variable Font Color in Combo Box 1
Setting a combo box value 8
Combo Box Question 4

Top