parameters on reports

  • Thread starter Thread starter Bhavin
  • Start date Start date
B

Bhavin

What is the method used to take a value from a field on a
form and use it as a parameter in a report that is
generated from a query, without the dialog box appearing
requesting the value off the form?

Thank you.
 
Hi Bhavin
In the Criteria of the field in the query behind the form
and report, type in the following:
Forms![formname]![controlname]
Hope This Helps
 
If the form is open and there is a value in the control (i.e. textbox) you
can refer to it in the criteria for the query. They syntax to do so is

[Forms]![FormName]![ControlName]

Access will probably put the brackets around each part for you, but if there
are spaces in the name, you may need to do it yourself.
 
What is the method used to take a value from a field on a
form and use it as a parameter in a report that is
generated from a query, without the dialog box appearing
requesting the value off the form?

Thank you.
Click to expand...

Use a criterion of

=[Forms]![nameoftheform]![nameofthecontrol]

The form must of course be open at the time the report is launched.
 
Back
Top