Set Chart RowSource in Report via code (1 Viewer)

[PaddyIrishMan]

Hi,
I have a chart on a Report, the report is based on a select query which gets parameters from controls on a form.

The problem is that the chart throws a wobbler & doesnt recognise the parameters - I assume this is because it's rowsource is a subquery of the reports main query.

Cutting to the chase.. I'd like to set the charts rowsource property in the report open event. There are no properties being exposed for the chart object in the code for the report. Does anybody know a way of doing this??

Thanks for your help,
Patrick.

 

[llkhoutx]

Try

docmd.openreport YourReportName
yourreportname.recordsource= -------
yourreportname.requery