title: Requery subform (1) after adding a new subform (1) record via pop-up subform (2) - Access 2007
body: <p>I have a form with two subforms (1 and 2).  Subform 1 stores the data continously for account breakdowns.  Using a pop-up subform (subform 2), the user enters data to change or update the account breakdown stored on subform 1.  On submit, the information is stored in the sub-table linked to subform 1, but the data does not refresh and add the new information in a new record in subform 1 unless I manually click the refresh all button in the home tab.  </p>
  
  <p>So far, I have tried the following code on form_afterupdate of subform 2, which does requery subform 1 automatically but creates a run-time error (2450) when the main form is closed: </p>
  
  <pre><code>Private Sub Form_AfterUpdate()
  
  On Error GoTo Err_Form_AfterUpdate
  
  Forms!frmSpendPlan!frmSpendPlanSub.Form.Requery
  
  Exit_Form_AfterUpdate:
  
  Exit Sub
  
  Err_Form_AfterUpdate:
  
  MsgBox Err.Description
  
  Resume Exit_Form_AfterUpdate
  
  End Sub
  </code></pre>
  
  <p>If anyone has a way to automatically requery subform 1 data once subform 2 is submitted without creating an error please let me know, I appreciate any help you can provide.</p>
  
  <p>Thanks!</p>