Accessing Query based on Combo box

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

Guest

I have an interesting dillema. I have a combo box in my for with 4 values
(A, B, C, D). What I would like to do is if a user selects A, B or C, the
results pull from query A but if they select D, the results pull from query
B. Is there a way to do this? Thanks.
 
I have an interesting dillema. I have a combo box in my for with 4 values
(A, B, C, D). What I would like to do is if a user selects A, B or C, the
results pull from query A but if they select D, the results pull from query
B. Is there a way to do this? Thanks.
Click to expand...


If you have a subform showing the results, set the rowsource in the
change event of the combobox. Just use a hidden column on your
combobox.
 
You can use a union query. First add criteria to the individual queries for
the A, B, C, or D.
Then put the queries in your union query. Only the selected query, criteria
matching combobox, will pull data and be displayed.
 
Back
Top