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

Subreport - Multiple parameter entries 2
Automatically Enter Parameter Value 2
Query parameters, charts, and reports in Access 2007 2
Report criteria requested 4 times 5
parameters using docmd.openreport 7
subreport repeating parameters 6
Reference controls on a dialogue form as the parameters 1
Parameters with mor than one crosstab query in a report. 8

Back
Top