I am reposting this from the Access Reports Forum. I still can't figure this out. 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. It was suggested that I add .text to my variable but that didn't work. Any suggestions would be welcome!! Thank you very much!!
Will
Will