Multiple queries with the same parameters

[DanAuber]

Is there an easy way to pass the same parameters to multiple queries ? The parameters are prompted for in query one, and then used in ten other queries - at the moment each time a new query starts, Access reprompts for the parameters.<br>I know I can get round this by writing the SQL in a VBA module and getting the parameters at the beginning, I just wondered if there were any other ways using the queries. (I also know you could do it by putting the parameters in a temporary table - but that doesn't seem too elegant)<br><br> <p>Dan Auber<br><a href=mailtoanAuber@aol.com>DanAuber@aol.com</a><br><a href=

http://members.aol.com/_ht_a/danauber/myhomepage/>Dan

Auber's Home Page</a><br>

 

[elizabeth]

The ususal method is to create a form that collects the parameters, then has a button to launch queries or reports.