janerussel
MIS
I have a main form with subform1 displaying a datasheet on the upper half of the form and subform2 displaying two detail memo fields on the bottom.
On the main form "On Open" event I have this code:
Set frmAgree.Form.Recordset = _
frmAgree2.Form.Recordset
which synchronizes the records, so that when I select a record in my subform1 datasheet view, the corresponding memo fields for the record are shown in subform2.
The problem is that when I sort ecords using the column headings in the datasheet view, the synchronizing no longer works.
My main form is not based on a recordset, and the subforms are both obviously based on the same recordset.
Anyone have a solution?
On the main form "On Open" event I have this code:
Set frmAgree.Form.Recordset = _
frmAgree2.Form.Recordset
which synchronizes the records, so that when I select a record in my subform1 datasheet view, the corresponding memo fields for the record are shown in subform2.
The problem is that when I sort ecords using the column headings in the datasheet view, the synchronizing no longer works.
My main form is not based on a recordset, and the subforms are both obviously based on the same recordset.
Anyone have a solution?
