Parameters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I run my report it asks for the parameter value three times each. Why does this occurr when the query its based asks for it just once.
 
Do you have subreports?

--
Duane Hookom
MS Access MVP


George Schneider said:
When I run my report it asks for the parameter value three times each.
Click to expand...
Why does this occurr when the query its based asks for it just once.
 
The query that the report is based on is based on three queries each asking for the same date ranage. The main query works fine asking only once for the values.
 
George said:
The query that the report is based on is based on three queries each
asking for the same date ranage. The main query works fine asking only
once for the values.
Click to expand...
George,
Use a Form to enter the parameter values.
Change the query parameter from something like:
Between [Enter Start Date] and [Enter End Date]
to
Between forms!FormName!StartDate And forms!FormName!EndDate

As long as the form is open when running the report, you will not be
asked for the parameters.

Open the Form in the Report's Open Event:
DoCmd.OpenForm "FormName", , , , , acDialog

Close the form in the Report's Close event.
DoCmd.Close acForm, "FormName"
 
Back
Top