Linked Access chart sometimes not updating properly

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In Access 2002, when printing 50+ graph reports, via macro, several
(different each time) show the original data on the graph, rather than the
live data.

Every report works properly individually, and every report that has failed
has worked before, successfully, without any subsequent design changes.

It just seems a few each run fail to update their data, when later, those
work, while others fail.

I have tried adding a macro step to "requery page" to the "on print" event
of the section of my report containing the linked form, but it doesn't solve
the problem.

Any ideas? I would greatly appreciate any help!

Thanks!

CalhounRaccoon
 
Never mind.

I found Duane's earlier post, helping someone else, and it worked.

FYI, he referred to a string of code including

"objGraph.refresh"

stored in the "on print" event of the report section.

I tried to use a macro to do "refresh page", but that didn't work. His code
did. I was trying to stay in the "macro world", avoiding the "code world" as
much as possible.

Thanks, Duane!

Calhoun Raccoon
 
Back
Top