Results 1 to 4 of 4
  1. #1
    tomnsd is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2013
    Posts
    17

    Report Charts won't 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?

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,441
    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.

  3. #3
    tomnsd is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2013
    Posts
    17
    The source data, queries and reports are all within the same access database. Nothing is hard coded into the graph.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    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.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Charts :( |*!%#!
    By libraccess in forum Reports
    Replies: 2
    Last Post: 05-08-2012, 12:55 AM
  2. Grouped Report with Charts
    By FL_Boy in forum Reports
    Replies: 2
    Last Post: 12-21-2011, 09:27 PM
  3. Multiple linked charts in a report
    By gonzo79 in forum Reports
    Replies: 0
    Last Post: 11-09-2010, 05:24 AM
  4. charts in reports
    By combine21 in forum Reports
    Replies: 3
    Last Post: 09-15-2010, 10:01 AM
  5. Create Multiple Charts for Report
    By Catch Wrestler in forum Programming
    Replies: 0
    Last Post: 06-21-2010, 10:50 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums