Report asks for parameter twice for every chart that I have in it

[Guest]

I have produced a report that is based on a parameter query. I created the
parameter to ask for "town "and "city". I grouped the data in my report based
on another feid. I have also added calculated controls and a chart to each
group within the report. For every chart that is in the report I am promted
to enter the parameter twice. I must do this when I open the report, print
the report(times every copy), send a .snp, and scroll through pages of the
report. How do I stop this while still qurying my report?????

 

[Duane Hookom]

Kick your development up a notch by not using parameter prompts in queries.
Use references to controls on forms for your criteria.

 

[Guest]

Can you explain a little more

Kick your development up a notch by not using parameter prompts in queries.
Use references to controls on forms for your criteria.

 

[Duane Hookom]

Always allow users to enter values into controls on forms for setting
criteria. For instance, you might have a form "frmRptDates" with two text
boxes "txtStart" and "txtEnd". Users can enter values into the text boxes
and run a query that has a criteria like:

Between Forms!frmRptDates!txtStart And Forms!frmRptDates!txtEnd