Date prompt appearing twice due to chart in report

[Guest]

Hi All,

I am creating a report based on a query. I have a prompt to ask for the
Beginning Date and the Ending Date. When I run the query I get the correct
results. I also get the correct results when I run the report. However, I
have just added a pie chart in my report footer, and because of this, I am
always forced to enter the beginning and ending dates twice when running the
report.

What do I need to do to make the prompt only appear 1 time for each date?

Thank you!

decklun

 

[Pat Hartman \(MVP\)]

The prompt appears each time Access needs to run the query. Once for the
report and a second time for the chart. The best solution is to use a form
to capture parameters and run the report from the form. The form can either
use the where argument of the OpenReport method or the report's queries can
refer to the form field rather than prompting.