Setting rowsource for a chart to the textbox from a form

[proben930]

I am building a combination of a search that outputs a chart, based on criteria selected. i have the form built properly, it returns a fully functional SQL statement into a textbox on the form (was going to set it invisible). I can put this SQL statement into the row source of the chart and it works great. But how do I make the report automatically look to this textbox?

[OLEUnbound0].RowSource = Forms![frmCharts]![Text37]

on the openreport event doesn't work, it says its a type mismatch. Help!

 

[Kodo]

I've tried to set the rowsource for a chart object in a report but apparently it can't be done in VBA.

Try putting this
Forms![frmCharts]![Text37]
as the rowsource for the Chart in the chart's "properties" instead of in VBA.