I created a chart in Access project using ActiveX control OCW10.ChartSpace on a form. It graphs the results of a query (reading from SQL2000 db) which is entered in the "CommandText" property of the control. I am trying to change this in VBA code but can't see it in the properties of the control (Me.Mychart. ...) ?
It seems that starting everything from scratch in VBA with:
Set oChart = CreateObject("OWC10.ChartSpace")
...
makes it possible but I want to skip all this. Are the controls the same and where to look for the CommandText in the VBA object??
Here are some of my control properties:
OLE Class: Microsoft Office Chart 10.0
Verb: 0
Class: OWC10.ChartSpace.10
...
ConnectionString: Provider=SQLOLED;...
CommandTest: select r,sbp,dbp from dbo.cbp