Cange the rowsource of a chart in a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,
My target is to change the rowsource of a chart in a report, at the runtime.

I tried two ways:
1-I've created a form with a chart (MyForm),where I can change the
rowsource, then opened MyReport where I've put a subform linked to MyForm,
Old data was displayed (recalc/requery don't work :S ).
2-I've tried hardky to change the chart Source from the Report, and
obviously, it did not work.

any help?
Thanks in advance.
jouj
 
The method that I use is to change the SQL property of the row source query
prior to opening the report.
 
is there another way? because my source changes (different Server, Database,
Username/password). so I want to be able to change the rowsource in the
runtime.
creating a temp table in MS Access is not what I want.

Thanks.
jouj
 
I don't understand how my solution is nixed because of the reasons you gave.
I didn't say anything about a temp table.
 
Back
Top