G
Guest
I have a report that contains a chart(graph). I want set the "rowsource" at
runtime. I used the following syntax, but it does not like the reference
syntax. I'm stuck.
-----
"[Reports]![chart1]![chartYTD].RowSource = "SELECT
[WeekNum],Sum([Apps_Sent]) AS [Apps Sent] FROM [qchart_Wk_apps] GROUP BY
[WeekNum];"
DoCmd.OpenReport "chart1", acPreview
runtime. I used the following syntax, but it does not like the reference
syntax. I'm stuck.
-----
"[Reports]![chart1]![chartYTD].RowSource = "SELECT
[WeekNum],Sum([Apps_Sent]) AS [Apps Sent] FROM [qchart_Wk_apps] GROUP BY
[WeekNum];"
DoCmd.OpenReport "chart1", acPreview