Results 1 to 3 of 3
  1. #1
    Tuckejam is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2020
    Posts
    168

    Multiple Sub forms in a form and only one updates qry info

    I have my form that allows you to choose the year and month so the sub-form will automatically filter to only those transactions.

    This works fine BUT when I created another qry and subform to only show the Grand Total Of transactions It will not update the data when a new date is selected

    Click image for larger version. 

Name:	Capture.PNG 
Views:	11 
Size:	28.7 KB 
ID:	42392

    Subform on the bottom of the form works and updates fine

    Subform on top will not update unless I move back and forth from design view.




    Thanks

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Try:

    Me![NameOfSubFormControl].Form.Requery

    in the AfterUpdate event of both combo boxes

    You will need to put the real name instead of [NameOfSubFormControl]
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  3. #3
    Tuckejam is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2020
    Posts
    168
    Yea I figured it out right before you replied.

    For some reason I had it in my head that the Me.Form.Requery code I had was general to the main form updating all queries for the form.

    need to add Me.Form2.Requery to the after update


    Thanks

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

Similar Threads

  1. Replies: 12
    Last Post: 02-19-2019, 08:00 AM
  2. Replies: 7
    Last Post: 01-01-2019, 01:47 PM
  3. Replies: 19
    Last Post: 08-10-2017, 01:49 PM
  4. Replies: 5
    Last Post: 05-12-2014, 09:43 AM
  5. Replies: 1
    Last Post: 12-13-2010, 04:06 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