I am trying to set up a search bar that jumps from one record, to the next record, and so on. The data that I am using repeats numbers, not a lot of them but enough to make it relevant. So far I have been able to build a code that when I enter my number in a textbox it jumps to the first instance that this number is found in my data and displays it on the form. I have not been able to get it to then jump to the NEXT instance of this number. I am not a great coder and I have been playing around with it, but my code that is currently able to find the first record is listed below, any help would be greatly appreciated!!
Private Sub cmdSearch_Click()
Dim bkmk As Variant
Dim strField As String
Me.RecordsetClone.MoveFirst
'Find the first record that matches what
'is in the search text box.
Me.RecordsetClone.FindFirst "[Inspection]![Loc #:] Like " _
& Chr(34) & Me.txtSearch & "*" & Chr(34)
If Me.RecordsetClone.NoMatch Then
MsgBox "No Dice"
Else
bkmk = Me.RecordsetClone.Bookmark
Me.Recordset.Bookmark = bkmk
End If
End Sub