parameters on reports

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

 

[Art]

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

 

[Wayne Morgan]

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.

 

[John Vinson]

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.

Use a criterion of

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

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