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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

raquelle007 - 26 Oct 2005 16:26 GMT

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

Reply to this Message

Duane Hookom - 26 Oct 2005 16:36 GMT

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

Signature

Duane Hookom
MS Access MVP

>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
[quoted text clipped - 5 lines]
> 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?????

Reply to this Message

raquelle007 - 26 Oct 2005 16:48 GMT

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.
[quoted text clipped - 8 lines]
> > 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?????

Reply to this Message

Duane Hookom - 26 Oct 2005 18:53 GMT

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

Signature

Duane Hookom
MS Access MVP

> Can you explain a little more
>
[quoted text clipped - 15 lines]
>> > the
>> > report. How do I stop this while still qurying my report?????

Reply to this Message