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]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Passing Criteria From a Form 1
Use In() Expression as Query criteria with guts from Function 1
IIf Criteria Question in a Query 4
VBA: How can I use a string variable as autofilter criteria? 4
passing a parameter based on multiple selections 7
Passing > or < from a form 2
Default Query Criteria 1
Query using multiple values from one text box 7

Back
Top