ClaraBarton
Registered User.
- Local time
- Yesterday, 16:58
- Joined
- Oct 14, 2019
- Messages
- 605
I have a subform with record selectors. The following is the form on click event:
The proper record is selected in the parent form but the continuous form subform selector jumps back to the first record. I can click the selector the second time and it stays. There is no other code in this module. There is no requery. It works fine but it doesn't look right because the two forms are on different records.
Code:
Private Sub Form_Click()
Dim rs As Recordset
Set rs = Me.Parent.RecordsetClone
With rs
.FindFirst "InvoiceID =" & Me.InvoiceID
If Not .NoMatch Then
Me.Parent.Bookmark = rs.Bookmark
End If
End With
Set rs = Nothing
End Sub