Access 2007 Graph not updating

[Troy]

I am using a subform and a main form. The subform contains fields which on
the after update event should update a graph on the main form. However I find
this only works if I physically mouse click on the graph. Sometimes the graph
goes blank and only comes back when I click it.

I have tried using refresh and requery on the graph itself, but nothing
works. Apparently this is a common problem with this version of Access. I
have the latest service pack installed also, but this has not resolved the
issue.

Any ideas or code appreciated.

Thanks

 

[Mark]

Hi

I've had simialr problems with graphs in reports in Access 2002 where the
answer has been to refresh the graph in code from the Detail_Print event so
the graph in the subreport refreshes every time it needs to be redrawn.
Without this the graph was sometimes empty and sometimes even displayed the
default design values!

Maybe try refreshing in code (eg Set objGraph = mygraph, objGraph.Refresh)
from an event that occurs when your data changes.... form's OnCurrent event
maybe.

Mark