Using forms to set parameters or criteria

  • Thread starter Thread starter Shiner452
  • Start date Start date
S

Shiner452

Is there any way I can use a form to set the parameters or criteria o
what gets posted on a report or a query
 
Yes! If you keep the form open while you run the query (or report based on
it), all you need to do to get form control values in the criteria of your
query is:

=Forms!FormName.ControlName (using the actual names, of course).

HTH,
Nikos
 
Is there any way I can use a form to set the parameters or criteria of
what gets posted on a report or a query?
Click to expand...

Certainly. Use a criterion such as

=[Forms]![NameOfYourForm]![NameOfTheControl]

The form (or at least the controls you use as criteria) should be
*unbound*, with no control source, in order to prevent altering data
in your table in the course of finding another record in the table.
 
Back
Top