Error in Report using a Chart filtered with RowSource

[lblanco]

HI!
I'a tring to use the rowsource in the open event of the report like:
me.GraphObject.rowsource = "TRANSFORM Avg(Query1.AvgOfMargin) AS AvgOfAvgOfMargin SELECT..."
But when I open the report it sends the error: "You entered an expression that has an invalida reference to the property RowSouce

Any idea???

 

[dhookom]

I don't think there is a way to set the row source of a graph in the on open event (or any other event) of a report. If your RowSource is a saved query, you might be able to change the SQL of the saved query which is similar but more likely to succeed.

Duane
MS Access MVP