Using Access 2000 I have a report containing a graph. This object has a pivot transform query to provide up to 10 series (lines) on the graph. A form is used to select values to be used in the graph.
I need to be able to change the rowsource contents of the graph depending upon the values selected on a parent form.
Can any one help with the vb code needed on the form (control button) which will allow me to specify the graph rowsource sql. I know what syntax I need for the sql but cannot find a method to update this into the graph rowsource.
I have tried to open the report in dev mode to update the row source this way but am unable to make this work (when I try to run the code it causes Access to close with a log file the name of which is not given).
Any help much appreciated.
I need to be able to change the rowsource contents of the graph depending upon the values selected on a parent form.
Can any one help with the vb code needed on the form (control button) which will allow me to specify the graph rowsource sql. I know what syntax I need for the sql but cannot find a method to update this into the graph rowsource.
I have tried to open the report in dev mode to update the row source this way but am unable to make this work (when I try to run the code it causes Access to close with a log file the name of which is not given).
Any help much appreciated.