How can I pass a value to the criteria line of a query from a form?

  • Thread starter Thread starter ZBC
  • Start date Start date
Z

ZBC

In one case I would like to pass a 'year' from a textbox on a form to an
expression in the criteria line of a query.
In another case, I would like to pass a string "AUTO" or "PROP"from a
textbox on a form to an expression in the criteria line of a query.
How do I do this?
 
In the criteria expression where you want to substitute the value from the
control, use this:
[Forms]![FormName]![ControlName]
 
Back
Top