Create Graph Dynamically 1

[jamez05]

I'm using Access 2003. Right now, a form holds a scatter graph made with MSGraph Chart 8. I need to add the form
as a subform to another page. I've done this, but the problem is I cannot get the graph to refresh.

I've searched the forms for ways to refresh a graph object and have looked for ways to build the scatter graph programmatically and haven't had any luck. Can someone point me in the right direction?

 

[grgimpy]

I've never used MSGraph Chart 8, but maybe you'd have better luck using an Access Pivotchart instead. Then you can use the OWC10 reference to build and manipulate the charts.

Pivotcharts can be refreshed in Access by using the Requery command (Me.[Subform Name].Requery).

 

[jamez05]

Thanks, that gives me something to look into.