dynamic graphs that auto update from query data

  • Thread starter Thread starter stephen
  • Start date Start date
S

stephen

Hi All.

As a novice user of reports in Access, could you advise on
the below;

Would I be correct in the assumption that when I am
creating chart reports in a wizard, they are not dynamic
with the data I use from the queries? When my data is
amended should the charts not also update?

If this is the case, could some explain why? And is there
an alternative to get truly dynamic graphs?

Many thanks for the good job all you guys are doing.

Stephen.
 
Stephen:

1.) Reports and charts will only update with refreshed data when the report
is closed and then reopened forcing a requery.
2.) Sometimes due to timing issues, the chart will fail to appropriately
refresh even if step 1 is performed. This can be corrected by adding a
little VBA code to to the section of the report that contains the chart
object. Stop by our web and look in the Code and Design tips area under
reports for the Common Graph problems and solutions for the code you need.

HTH
 
Back
Top