Show records from query 1 or query 2 depending

G

Guest

Is there a way to write a third query that shows the
records on a form to be from using either query 1 OR
query 2 depending on which query was run? That is, if
user chooses to run query 1, then show records from query
1. If user chooses to run query 2, then show records
from query 2. I don't want query 1 to filter query 2.

Would this same method work if a 4th, 5th etc. query were
used?
Thanks
 
V

Van T. Dinh

Try changing the RecordSource of the Form by code.

Check Access VB Help on the RecordSource Property.
 
Top