parameter query

G

Guest

I have created a couple parameter queries and would like to create a query
that when ran would prompt me to choose one of the parameter queries I have
already created is this possible? For example:
I have q1, q2, q3, q4, q5 (query example names). I run q6 and it prompts me
to choose either q1, q2, q3, or q4. Once I choose one of the first 5 queries
then it runs that query normally.
 
D

Duane Hookom

Are all the fields the same in q1-q5? If the fields are different, you might
need to run code after the selection of the query name. The code would
modify the sql property of a saved query.

Your posting begs the question "why is your application set up like this"?
 

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

Top