Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2008
    Posts
    27

    Unanswered: Requery a Subform

    So I have a subform2 that captures the sum of another subform1. I want to have the totals subform2 requery in real time when the subform1 is updated. I have done some research but am not having any luck. Here are the actual names I have:

    [DailyWorkTotals subform]![SumOfNumber of Loans Worked]
    this needs to requery when this below field is updated:
    [DailyWorkQry subform]![Number of Loans Worked]

    Thanks!

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Try

    Forms!MainFormName.SubformControlName.Requery

    Note that the subform control on the main form could have a different name than the subform itself, and it's the name of the control that you want.
    Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •