Apply Parameters to Multiple Queries

  • Thread starter Thread starter JoeCL
  • Start date Start date
J

JoeCL

Hello!

Is there a way to pass on parameters value from one query
to another query without prompting to re-enter the values.
Two queries use the same parameter values. Thank you.

Joe
 
create fields to hold the parameter values. Then, they
are accessible in subsequent queries.

ex. In query 1, add into query grid:

parm1:[enter parameter]

Query 2 uses query 1, and parm1 is a field that can be
selected from query 1.
 
Joe,

One way is to forget the idea of a Parameter Query altogether, and
instead use unbound controls (textbox, combobox, option group, as
applicable) on a form which will be open at the time that the queries
are run. The user can enter the criteria in here, and you can refer to
these controls in the Criteria of your queries, in place of the existing
parameter prompts, using syntax such as...
[Forms]![NameOfForm]![NameOfControl]
 
Back
Top