JLAZ
Registered User.
- Local time
- Today, 08:25
- Joined
- Sep 17, 2003
- Messages
- 24
I have an unbound search text box
Heres is the code
Me.RecordsetClone.FindFirst "SerialNumber = " & SearchStock
If Me.RecordsetClone.nomatch Then
MsgBox "Stop You Made a Mistake"
Me!Technician.SetFocus
Me!SearchStock.SetFocus
SearchStock = Null
Exit Sub
End If
Me.Bookmark = Me.RecordsetClone.Bookmark
SearchStock = Null
what I need is for if the user types in the same record it is already on for it not to navigate to the next record and set the focus back to the SearchStock text box
Heres is the code
Me.RecordsetClone.FindFirst "SerialNumber = " & SearchStock
If Me.RecordsetClone.nomatch Then
MsgBox "Stop You Made a Mistake"
Me!Technician.SetFocus
Me!SearchStock.SetFocus
SearchStock = Null
Exit Sub
End If
Me.Bookmark = Me.RecordsetClone.Bookmark
SearchStock = Null
what I need is for if the user types in the same record it is already on for it not to navigate to the next record and set the focus back to the SearchStock text box