I added two charts to a report that I built. The charts are based on two separate queries. I have changed the data behind the queries, but when I open the report, the charts do not update. Do I have to add code or something so the charts update?
I added two charts to a report that I built. The charts are based on two separate queries. I have changed the data behind the queries, but when I open the report, the charts do not update. Do I have to add code or something so the charts update?
Are your charts based on data within your database or are they external? (i.e. you do the charting in excel then import that chart as an image back into access)
If the charts are built in MS access check the rowsource of the charts to make sure they're showing you the data you want. If you've hard coded the criteria of a chart it'll never change if you run it for a different time period, etc.
The source data, queries and reports are all within the same access database. Nothing is hard coded into the graph.
Charts do not require code for updating. Just like the RecordSource of a form/report, chart data is dynamic. I have many charts that automatically reflect data edits.
rpeare poses good questions for you to consider. If you need more help, maybe provide db for analysis. I can best analyse chart issues by working with data.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.