change chart rowsource at run time

[iccsi]

I use the following code to change chart row source at run time, but I
got error message.

grpDetails.RowSource = "MYQUERY"

I just wonder does MS Access 2003 support to change chart rowsource at
run time?

It it does, are there any sample code for this?
If not, is it the best solution to have multi charts on the report
and control visible property accordingly?

Your information and help is great appreciated,

 

[Duane Hookom]

Attempting to change the Row Source of a chart control on a report is similar
to changing the Record Source of a subreport on a main report. It isn't easy
to accomplish due to the timing of the rendering.

I generally set the Row Source to a saved query. Prior to opening the
report, I use a little DAO code to change the SQL property of the saved query.

I assume you understand you can use the Link Master/Child properties of the
Chart Control to 'filter' records displayed in the chart.

 

[inungh]

Attempting to change the Row Source of a chart control on a report is similar
to changing the Record Source of a subreport on a main report. It isn't easy
to accomplish due to the timing of the rendering.

I generally set the Row Source to a saved query. Prior to opening the
report, I use a little DAO code to change the SQL property of the saved query.

I assume you understand you can use the Link Master/Child properties of the
Chart Control to 'filter' records displayed in the chart.

--
Duane Hookom
Microsoft Access MVP









- Show quoted text -

Thanks millions