Results 1 to 3 of 3
  1. #1
    accessnewbie352 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2015
    Posts
    46

    AutoRefresh Form Not Working

    I am updating someone else's database and it originally had an autorefresh on a form. When you click into a section on the main form (A), a new form (B) will pop up where you enter the value. When you hit close on form B, the value will then automatically appear on the original form A. For some reason, the automatic refresh is no longer working. The value now only changes in form A when I manually hit "Refresh" on the ribbon. I checked the form property and the "Timer Interval" is set to 0 already.




    I also tried creating a requery macro but it did not work either.


    How do I make the form automatically refresh??

  2. #2
    Rawb is offline Expert
    Windows 7 64bit Access 2010 32bit
    Join Date
    Dec 2009
    Location
    Somewhere
    Posts
    875
    Probably the easiest thing to do would be to requery Form A in the On Close Event of Form B. Unless you want to catch Records added by other users in real time, there's no reason to Requery on a timed interval.

  3. #3
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    Quote Originally Posted by accessnewbie352 View Post

    ...I checked the form property and the "Timer Interval" is set to 0 already...
    Why did you mention the above fact? Do you think that the Timer is being used to run the Refresh? The Timer Interval set to 0 means that the Timer is not running at all.

    Linq ;0)>

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

Similar Threads

  1. Replies: 13
    Last Post: 01-22-2015, 05:27 PM
  2. Replies: 8
    Last Post: 01-13-2015, 12:23 PM
  3. Replies: 3
    Last Post: 01-29-2013, 04:34 AM
  4. Replies: 2
    Last Post: 03-21-2012, 10:36 AM
  5. Replies: 2
    Last Post: 08-18-2011, 10:20 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