Accessing Query based on Combo box

[dwaynesworld]

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.

 

[pietlinden]

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.

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.

 

[KARL DEWEY]

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.