title: Requery a subform from another form?
body: <p>I've struggling with this problem on my own, then with some help, then search about it; but I haven't had any luck. So I decided to ask.</p>
  
  <p>I have two forms in <em>Access 2007</em> lets call them <code>MainForm</code> and <code>EntryForm</code>.<br>
  <code>MainForm</code> has a subform and a button. The button opens the <code>EntryForm</code> in Add Mode. What I want to do is when the <code>EntryForm</code> saves the new record it would update (requery) the subform in <code>MainForm</code>.</p>
  
  <p>I've try this setup code</p>
  
  <pre><code>Private Sub cmdSaveAndClose_Click()
      DoCmd.Save
  
      'requery list
      Forms![MainForm]![subformName].Requery
  
      '' I've also tried these
      'Forms![MainForm]![subformName].Form.Requery
      'Forms.("MainForm").[subformName].Requery
      'Forms.("MainForm").[subformName].Form.Requery
  
  
      DoCmd.Close
  End Sub
  </code></pre>
  
  <p>None of these attempts seem to work. Is there a way to make this requery?
  Thanks for the help in advance.</p>