Results 1 to 6 of 6
  1. #1
    joe55555 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2013
    Posts
    24

    how to auto update a report ?

    hello,



    i have a complete access database with forms and queries and reports.

    the only problem i am facing is that when i create a new report it only takes the data already entered.
    if i modifiy or change a record in the form or table the report doesn't update the modifed data it stays as it is before and i have to re-create a new report.

    is there any way to deal with this and make the same report auto refresh the data modified or no ?
    thanks

  2. #2
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    What is the Data Source of your Report? Is it based on the table or query that is getting updated?
    How are you running your Report?
    When are you running your Report, in relation to the timing of when your data is being updated? If your Report is open while you are updating the data on your Form, you will probably need to refresh your Report (or close and re-open it).

  3. #3
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    It you base your report on a static query (one that has been saved) this should not happen.

  4. #4
    joe55555 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2013
    Posts
    24
    i have some reports based on tables and others coming from queries

    i tired the refresh thing and it didn't work

  5. #5
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,931
    Want to provide db for analysis? Follow instructions at bottom of my post.
    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.

  6. #6
    joe55555 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2013
    Posts
    24
    June7
    thank you it worked well now

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

Similar Threads

  1. Another way to Auto Update of Front End
    By rankhornjp in forum Code Repository
    Replies: 23
    Last Post: 03-12-2014, 10:43 PM
  2. Auto Update Question
    By LionsCricket in forum Access
    Replies: 3
    Last Post: 04-11-2013, 03:22 PM
  3. Auto-increment fields update
    By rkalapura in forum Forms
    Replies: 3
    Last Post: 01-07-2012, 06:37 AM
  4. Auto Run Report then Auto Email
    By jo15765 in forum Reports
    Replies: 1
    Last Post: 10-05-2011, 10:57 AM
  5. Auto Update Forms
    By Vikki in forum Forms
    Replies: 1
    Last Post: 02-09-2010, 10:51 AM

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