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,550
    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 Access MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    6,204
    Try requerying the subform after making any changes
    Colin Riddington, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I know I don't know, I keep quiet!

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