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 subform1.Form.Recordset = _
subform2.Form.Recordset
which synchronizes the records. When I select a record in my subform1 datasheet view, the matching memo fields for the record are shown in subform2.
The problem is that when I sort or filter records 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 subform1.Form.Recordset = _
subform2.Form.Recordset
which synchronizes the records. When I select a record in my subform1 datasheet view, the matching memo fields for the record are shown in subform2.
The problem is that when I sort or filter records 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?
