Variable Chart Rowsource Data

[weckels]

I have a chart in the detail section of a report. The report is ran from a button on a form. I want the chart in the report to use data from a table specified on the form. In the chart properties - Row Source - I entered =[forms]![ins report form]![insdata]. Insdata is a text box that contains the name of the table I want to use. The problem is that I get a message that the record source does not exist. It really does exist so I don't know what is wrong. Any suggestions would be welcome!! Thank you.

Will

 

[dtheriot]

I've never actually tried this, but you might try using this: [forms]![ins report form]![indata].text. I think it is trying to actually use the text box control as the data source. If you use the text property of that control, it may use the value of what's in the text box.

 

[weckels]

dtheriot,
I added the .text and got the same result. Thanks for the suggestion.

Will

 

[watty215]

Instead of trying .text try .value this may work