Chart report doesn't refresh

  • Thread starter Thread starter lucy wang
  • Start date Start date
L

lucy wang

Hi,
I try place code in the On Format event of the section
that contains the Chart:
Me!chartMyChart.Requery. But old chart still doesn't go
away. I looked into the design view it is there. Is there
any way to flush it or clean the data before the report
open. Thanks!
 
No. The report is based on the query which is generated
when you enter date range in the form. But the query is
right each time you change the date range. I found
sometimes the old graph left in the design view and comes
up even though you change the query.So I don't know if
there is any way to flush or clear the graph data in
design view before the report opens.Thanks!
 
The data won't refresh while in design view. I generally build all graphs on
a form. Set them to Locked: No and Enabled: Yes. You can then open the form
in design view and double-click the report to load the data. Then go back to
design view and copy the graph back to the report.

This might not help with refreshing the data. I have always had good luck
with code that requeries the graph.
 
Back
Top