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
what gets posted on a report or a query
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
N
Nikos Yannacopoulos
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
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
J
John Vinson
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?
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.