Here's a quote from form.recordsource from MSDN:
"Changing the record source of an open form or report causes an automatic requery of the underlying data. If a form's Recordset property is set at runtime, the form's RecordSource property is updated."
Say, I have a main form that has two separate subform controls, each of which has sourceobject points to a single form - FrmB
naming one subform1.form.recordsource to a SQL statement that picks out 2*n elements of a set
and another subform2.form.recordsource to another SQL statement that picks out 2*n-1 elements of the same set
Would the second subform2 control reset the form record data already opened in subform1 control?
In other words, are two separate subform controls actually holding a cloned form (derivative of frmB) where opening of one does not affect the recordset of the other?