Results 1 to 2 of 2
  1. #1
    schwabe is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Jan 2012
    Location
    San Francisco Bay Area
    Posts
    50

    Auomatic Update of Report

    Hello all,

    When I change some data in my input forms (which use queries as data sources), the report does not update unless I click "Refresh all".
    How can I do that automatically?

    Thanks,


    Benjamin

  2. #2
    schwabe is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Jan 2012
    Location
    San Francisco Bay Area
    Posts
    50
    Okay, I've done the following:


    Private Sub Report_Activate()
    Me.Requery
    End Sub
    Private Sub Report_GotFocus()
    Me.Requery
    End Sub
    Private Sub Report_Load()
    Me.Requery
    End Sub

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

Similar Threads

  1. Query to automatically update report
    By kathi2005 in forum Access
    Replies: 13
    Last Post: 10-31-2011, 05:01 PM
  2. How to make a button on a form update report
    By Enemee in forum Programming
    Replies: 1
    Last Post: 07-05-2011, 11:24 AM
  3. Report does not update properly
    By Tari in forum Reports
    Replies: 7
    Last Post: 03-08-2011, 05:20 PM
  4. Importing new time for header and update report
    By spamvalley in forum Reports
    Replies: 2
    Last Post: 02-16-2006, 11:23 AM
  5. Replies: 1
    Last Post: 12-09-2005, 09:16 PM

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