Graph Does Not Update

[Casey]

Hi,

I have a graph in a report that I am using. This
graph is reliable most of the time, but occasionally it
does not show the data that should be in it.

In the Event Procedure I use to open the report that
has this graph in it, I open the query that is used by
the chart, requery it, and close the query. When the
report opens up after that, it sometimes has not updated
its data yet.

Is there something I can do to make sure the graph
shows the most up to date data.

I would appreciate any advice.

Thank you,

Casey

 

[Kacie]

Hi Casey, I'm Kacie also and I have had this problem. See
article 318079. I just added a me!graph1.requery to the
On Format event like this:

' Replace objMyGraph with the name of your object.
Me!objMyGraph.Requery

Kacie

 

[lucy wang]

Hi,
Have you figured it out? I have the same question with you.

I have created a Chart Report using MS Chart 2000 by
entering the date range in the form. Sometimes when I
change date range the old chart doesn't go away(I use
local table as record source, and the source data is
right.). I think there should be some refresh function, or
there is some method to kill old chart in the memory.Your
help will be highly appreciated.