Can someone help me with this?
I have an Unbound Object Frame (chart) in the detail section of a report. The chart's rowsource is a few fields from another query. I would like to filter the results of the chart. In the VB code I typed:
Chart1.Report.Filter = sql
where sql is the select statement. However, I get an error message stating I entered an expression that has an invalid reference to the property Form/Report. Can someone tell me the correct syntax to use to filter a chart on a report? Thanks.
Rosebud
I have an Unbound Object Frame (chart) in the detail section of a report. The chart's rowsource is a few fields from another query. I would like to filter the results of the chart. In the VB code I typed:
Chart1.Report.Filter = sql
where sql is the select statement. However, I get an error message stating I entered an expression that has an invalid reference to the property Form/Report. Can someone tell me the correct syntax to use to filter a chart on a report? Thanks.
Rosebud