Results 1 to 2 of 2
  1. #1
    Njliven is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2012
    Posts
    86

    Requery Subform From another Subform

    Here is my issue. I have a main form that has two subforms, subform1 and subform2, both connected to the main form.
    When I enter data into a field in subform1 I want subform2 to requery and update to show the calculated results from the new or changed data in subform1.


    I found that if I do a refresh it works when changing the data but not when entering a new line of data in subform1. I tried some code in the after update field of on subform1, but cannot seem to get anything to work.

    Me.[subform2].Form.Requery Does not work.
    It errors and says it cannot recognize subform2 as a field.
    I have tried a field name on subform2 but I still got the same error.
    Thanks for any help I can get.

  2. #2
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Subform Requery Trouble
    By ztpkng in forum Forms
    Replies: 2
    Last Post: 06-19-2014, 04:02 PM
  2. requery subform
    By nswhit in forum Forms
    Replies: 2
    Last Post: 05-16-2013, 09:34 AM
  3. requery in subform
    By putte11 in forum Forms
    Replies: 7
    Last Post: 04-22-2013, 02:43 PM
  4. Replies: 3
    Last Post: 04-17-2012, 10:28 AM
  5. Refresh Requery Subform
    By eww in forum Programming
    Replies: 1
    Last Post: 04-05-2011, 09:19 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