How do i update a subforms subform?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • bev stubbs
    New Member
    • Jan 2012
    • 1

    How do i update a subforms subform?

    Hi I'm using access 2003. I have a main form, with a tab control that has a subform with a subform. When I select an option from a combo box on the first tab of the tab control I need a field in the subform and subsubform to update. So far I can get it to work, but only the first record in the subsubform updates - the subsubform is display as a continuous form. I am using the following as an event from the combo box
    Code:
    [frmActionPlanHeader].Requery
    [frmActionPlanHeader]![frmActionPlanDetails subform].Requery
    thanks
    Last edited by NeoPa; Jan 18 '12, 06:13 PM. Reason: Added mandatory [CODE] tags for you
  • Rabbit
    Recognized Expert MVP
    • Jan 2007
    • 12517

    #2
    Code:
    [frmActionPlanHeader]![frmActionPlanDetails subform].Form![some other subform].Requery

    Comment

    • NeoPa
      Recognized Expert Moderator MVP
      • Oct 2006
      • 32633

      #3
      You should be able to work it out from Referring to Items on a Sub-Form, but in this case, where we don't know the name of your sub-sub-form it could be :
      Code:
      [frmActionPlanHeader].[frmActionPlanDetails subform].Form.[Some Other Subform].Form.Requery
      or, alternatively :
      Code:
      [frmActionPlanHeader].[frmActionPlanDetails subform]![Some Other Subform]!Requery

      Comment

      Working...