Results 1 to 3 of 3
  1. #1
    Chuck is offline Advanced Beginner
    Windows 10 Access 2003
    Join Date
    Jul 2019
    Posts
    49

    subform will not update/refresh unless I close Access and then re-open it

    I was previously using Access V2003 in V2000 file format.


    I recently installed the current version of Access by way of installing Office 365.

    My primary form (formA), contains a subform (subB2)
    The underlying table for subB2 is tableB.
    subB2 presents a limited amount of data compared to formB2, which is also associated with tableB

    Previously (in Access V2003), if I made an addition or change to formB2 and then went back to my main form (formA), the change would appear in the subform.
    Now, the change only appears if I exit Access and then re-open it.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,549
    in the subform property, make sure:
    the LInked MASTER FIELD/Link child field properties are set
    filter=""
    FILTER ON LOAD = true

    if fails , try
    FILTER ON LOAD = false

  3. #3
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    6,127
    Try requerying the subform after making any changes
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

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

Similar Threads

  1. Replies: 3
    Last Post: 04-11-2015, 03:35 PM
  2. Replies: 4
    Last Post: 10-09-2014, 07:09 PM
  3. Replies: 4
    Last Post: 07-19-2014, 12:39 PM
  4. Refresh subform while after update
    By Ruegen in forum Programming
    Replies: 1
    Last Post: 04-10-2014, 11:09 PM
  5. Replies: 13
    Last Post: 02-04-2013, 04:08 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