M
Matt
I have a form containing an OLE object that is linked to an MS Excel bar
chart. The update property is set to automatic. The chart is updated from a
query that is exported before the form opens. When the form opens, the
object sometimes does not refresh and displays an old chart from when I
created the OLE object. I tried OLEobject.Refresh and also a timer to allow
the chart to update with the new data, however it still does not work. Any
suggestions on how to update the chart each time the form opens?
Thanks,
Matt
chart. The update property is set to automatic. The chart is updated from a
query that is exported before the form opens. When the form opens, the
object sometimes does not refresh and displays an old chart from when I
created the OLE object. I tried OLEobject.Refresh and also a timer to allow
the chart to update with the new data, however it still does not work. Any
suggestions on how to update the chart each time the form opens?
Thanks,
Matt