Passing a parameter to a Chart object in a report

[Guest]

I have made a parameter query that asks for a start and end date. These parameters pass just fine into the report with no issues. I want to create a chart using the data that is selected with the parameter query, which seems easy enough. The chart is bound to the query just like the report, but when I run the report, I have problems

The report itself works fine, and uses my parameters to gather the data. But when go to the page where the chart resides, it asks for the parameters again, almost like the query has to be re-run. Is there any way that I can pass the parameters input at the start of the query/report to the charts so you don't have to re-input?

I got around this by changing the query to a temporary make-table, and then using the created table as the source data for the report and the chart. However, I would prefer not to do the make-table, as you always get the warning message that the make-table query will delete current data. It's just a temp table for the use of the report, but usability-wise, I don't like it.

Any ideas would be greatly appreciated.

 

[Duane Hookom]

I recommend that you never use parameter/prompt queries. It is much more
effective to use references to controls on forms.
WHERE [SomeDate] BETWEEN Forms!frmDates!txtStart AND Forms!frmDates!txtEnd

--
Duane Hookom
Microsoft Access MVP
Please direct any questions to News Groups

I have made a parameter query that asks for a start and end date. These

parameters pass just fine into the report with no issues. I want to create
a chart using the data that is selected with the parameter query, which
seems easy enough. The chart is bound to the query just like the report,
but when I run the report, I have problems.

The report itself works fine, and uses my parameters to gather the data.

But when go to the page where the chart resides, it asks for the parameters
again, almost like the query has to be re-run. Is there any way that I can
pass the parameters input at the start of the query/report to the charts so
you don't have to re-input?

I got around this by changing the query to a temporary make-table, and

then using the created table as the source data for the report and the
chart. However, I would prefer not to do the make-table, as you always get
the warning message that the make-table query will delete current data.
It's just a temp table for the use of the report, but usability-wise, I
don't like it.