Results 1 to 3 of 3
  1. #1
    mikichi is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Oct 2013
    Posts
    45

    question| refresh form

    hi,
    i have 2 forms:


    Form1 - Separate view form and Form2 - regular view form.
    in Form1 i have a column with filter, in Form2 i update fields of column that i filtered in Form 1.
    i want that when i close Form2. Form1 update immediately(now Form1 update only if i click Refresh in the top toolBar of access)
    i try to write:
    studentsList.Refresh

    Form1 didn't update/
    thank youuu,
    miki

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows XP Access 2003
    Join Date
    Aug 2013
    Posts
    7,862
    Refresh will not include new records that were added to tables outside of the form's recordset. Try using .Requery. This will requery the the DB tables and look for any changes including new records/rows within the tables.

  3. #3
    mikichi is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Oct 2013
    Posts
    45
    requery work wonderful

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

Similar Threads

  1. Replies: 4
    Last Post: 03-26-2012, 12:45 PM
  2. Replies: 1
    Last Post: 01-24-2012, 03:47 PM
  3. Access 2010 Refresh VS Refresh ALL
    By Snwboarder1982 in forum Access
    Replies: 1
    Last Post: 09-09-2011, 04:07 PM
  4. Refresh Form
    By tpcervelo in forum Forms
    Replies: 7
    Last Post: 02-07-2011, 08:03 AM
  5. refresh a form
    By RedGoneWILD in forum Forms
    Replies: 18
    Last Post: 09-03-2010, 08:31 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