Need Record To Stay Where it is

JLAZ

Registered User.
Local time
Today, 06:44
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
 

Users who are viewing this thread

Back
Top Bottom