I am new to Access (97). I have read through the forum and am unable
to find a solution to my problem.
I have 4 separate queries designed. I have a form for each query.
The queries work fine when I run them on their own. However, instead
of having 4 separate queries on 4 separate forms, I want to combine
all the queries onto one form.
This will enable the user to select the query based on the value in
the combo box. Example: query_date, query_name, query_location,
query_employee. The user would then type the criteria into the text
box and click on "search".
As I said before, this works fine for each query that I run separately.
I just want to have the ability to use one form for all queries.