Parameters

G

George Schneider

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

Duane Hookom

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

George Schneider

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

fredg

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"
 

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

Amending meeting cancels all future meetings 0
Insert name and adress from a list in a word document 1
Subreport - Multiple parameter entries 2
ASK Field Formatting 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
parameters using docmd.openreport 7
Automatically Enter Parameter Value 2
Report criteria requested 4 times 5

Top