title: Issues with subforms in MS Access 2010
body: <p>I'm having an issue with MS Access 2010 which drives me crazy. 
  I do have a form with some subforms. The subforms are not linked to the main form, but their recordsource queries on some fields on the mainform.
  So far so good. If I change the values of the fields on the mainform the subforms are showing the correct records.</p>
  
  <p>However when I reset the values on the mainform with some VBA code the issue begins.</p>
  
  <p>Let's say one of my subforms has the following sourceobject: </p>
  
  <pre><code>Me.[Subformulier].SourceObject = "Form A"
  </code></pre>
  
  <p>When I reset the mainform I use below code:</p>
  
  <pre><code>Me.[Subformulier].SourceObject = ""
  
  ..
  execute some code
  
  ..
  
  Me.[Subformulier].SourceObject = "Form A"
  </code></pre>
  
  <p>However my Subform isn't returning any records.
  The funny thing is however when I open the subform it is showing exactly the records I was looking for...</p>
  
  <p>Can anyone help me with this?</p>