Results 1 to 4 of 4
  1. #1
    SlowPoke is offline Novice
    Windows XP Access 2010 (version 14.0)
    Join Date
    Sep 2010
    Posts
    11

    update/refresh form


    I've created a form, using various tables, sub-forms, etc. When record is updated I've noticed that not all the "boxes" on the form are updated. How can I "refresh" a form when a record is changed. I thought of adding a "refresh" button, but don't know what to attach to it. Any ideas?

  2. #2
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    1,295
    where and how do you update the data?
    put the refresh or requery after the data is updated.

  3. #3
    SlowPoke is offline Novice
    Windows XP Access 2010 (version 14.0)
    Join Date
    Sep 2010
    Posts
    11
    Data is updated on the same form. For example, records containing dollar amounts are entered on a sub-form. On the same form, but at a different location I calculated a total. I noticed that the total does not calculate quick enough.

  4. #4
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    1,295
    try to put the requery in the after_update event of the amount field in the sub form

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

Similar Threads

  1. refresh a form
    By RedGoneWILD in forum Forms
    Replies: 18
    Last Post: 09-03-2010, 08:31 AM
  2. update imported table like a refresh
    By cmul in forum Access
    Replies: 1
    Last Post: 09-02-2010, 09:28 AM
  3. Update/ Refresh Query
    By Vikki in forum Queries
    Replies: 0
    Last Post: 03-23-2010, 06:59 AM
  4. refresh update data problems
    By whm1 in forum Forms
    Replies: 1
    Last Post: 03-19-2010, 01:49 PM
  5. Refresh form search text box
    By oxicottin in forum Forms
    Replies: 2
    Last Post: 11-19-2007, 02:28 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