Is there any way to reliably change the rowsource for a chart embedded in an Access 97 form?
I’ve got the basic chart working, and it can display different datapoints depending on the value of a single field (ie, the field named in the LinkChild property of the graph object). What I want to do is to select rows depending on different fields. The table contains fields called type, size, and task, and I would like to able to create charts for different values of type, size, or task.
Every combination of queries and link fields that I’ve tried fails in one way or another.
Using Access 97. The object on the form is type MSGraph.Chart.8
