Another question, say there is two "Does". One in one company, and One in the other. When you go to the next company, the code doesnt work anymore and highlights the first record again. Any suggestions?
There are several ways to fix that. One of them is to add something like this to the On Current event of the subform:
Code:
If Parent.RecordSource <> "Accounts" Then 'is a select query when the search has results
Me.RecordsetClone.FindFirst "[Last Name] Like '" & Parent.txtSearchLast & "'"
Me.Bookmark = Me.RecordsetClone.Bookmark
End If