title: MS Access 2007 subform reload on formheader = visible?
body: <p>I'm getting strange behavior in Access 2007 on a form designed in Access 2003.</p>
  
  <p>I have an unbound main form with a data-bound subform. Within the Form_load of the main form, I set the subform sourceobject, which loads the subform recordset, etc. After the subform loads, but still within the Form_load of the main form, I set <code>Me.FormHeader.Visible = True</code>. After this line runs, for some reason the subform seems to close and reopen -- its Form_Unload fires, and it runs through its load process again.</p>
  
  <p>Any idea why this would be happening? It's annoying, because its recordset is based on a parameter query, and the parameters get zapped when it reloads so it ends up prompting users for parameters.</p>