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.
 
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

Date parameters for report 2
Parameter Value error in a Subform 0
Parameter prompt with form recordsource using combobox criteria 2
Using a form to input update query criteria 2
two questions on exporting from a form 3
Set criteria and have information display in form 1
Question reg Form and Report Parameters 11
combobox not displaying results 2

Back
Top