Results 1 to 4 of 4
  1. #1
    aaslezak is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2015
    Posts
    34

    Unhappy Report not updating change in query


    I changed the query that my report is based on only the changes are not being reflected in the report. Is there something that I have to do to update my changes from my query to get it to display on the report. I run them both side by side in tabs and they do not contain the same data and they should. I am not doing any filtering on the report, I just do a sort and group.

  2. #2
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    If you have the Report open while you are making data changes, you will probably need to close that Report and re-open it to see the changes.

  3. #3
    aaslezak is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2015
    Posts
    34
    I have done that twice and not effect. But once I closed the Data base and reopened it then it took the new changes, so thanks for the help.

    Al

  4. #4
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    You probably need to close the query too (which closing the database would accomplish).

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

Similar Threads

  1. Replies: 1
    Last Post: 07-14-2014, 10:45 PM
  2. Change field criteria in a report, or query
    By mdnikki in forum Reports
    Replies: 3
    Last Post: 10-05-2012, 12:43 PM
  3. Verify values change before updating record
    By gopherking in forum Forms
    Replies: 6
    Last Post: 07-19-2011, 11:46 AM
  4. Change color font when updating data?
    By Mike1379 in forum Reports
    Replies: 3
    Last Post: 05-17-2010, 08:00 AM
  5. Updating subform based on combo box change
    By kev921hs in forum Forms
    Replies: 3
    Last Post: 04-01-2010, 08:43 AM

Tags for this Thread

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