Multiple queries with the same parameters 1

[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>

 

[famousb]

when you are saying &quot;parameters&quot; i'm assuming you're using the criteria in your queries to limit the returned records, is this correct?<br>i'm also assuming that you mean that all ten queries are using the same criteria and therefore prompting for the same parameters.<br>instead, for queries 2-10, why not have their criteria simply reference query 1's fields?<br><br>ie.<br>for Field1 of Query2 put in the criteria:<br>=[queries]![Query1]![Field1]<br><br>is this what you're looking for? <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br>