My parent form displays key data for a single record and my subform displays summary data for multiple records. The two forms are NOT linked and there is no On Current event for the parent form. When I run the following code from the subform, the parent moves to the correct record but the subform refreshes and moves back to the top of the list. Is there any way to stop this from happening? I want the subform display to remain as it was before this code runs.
Set rs = frm.Parent.Recordset.Clone
rs.FindFirst "DetailId = " & DetailId
If Not rs.EOF Then
frm.Parent.Bookmark = rs.Bookmark