Passing Parameters to a Query

  • Thread starter Thread starter Berny
  • Start date Start date
B

Berny

Can anyone tell me if it is possible to pass the parameters from a form or
report to a Query?

I'm looking to pass the parameters to the query in a similar manner as using
the input box for passing filter parameters.

Is this possible?

Were can I look? What is it called? I haven't been able to find any
examples.

Any help would be greatly appreciated.
 
Can anyone tell me if it is possible to pass the parameters from a form or
report to a Query?
Click to expand...

Certainly. Use a criterion of

=[Forms]![NameOfForm]![NameOfControl]

The form must be open at the time the query is run. It's typical to
base a Form or Report on the query, and put a button on the unbound
criteria form to open the data display object (Form or Report).
 
Back
Top