Need form to go to record based on user input

[z.heineman]

I am trying to create a "simple" form where the user will type check
number and hit enter and it will pull up the status of whether it is
processed or not. But I am unable to navigate this way, it simply
changes the data for the record I am on. The users will not know what
records pertain to what check number. So how do I make the form update
based on what they enter?

Many thanks.

 

[z.heineman]

I am really needing some help with this. It seems like something that
should be very simple or a dang button! Please help.

Thanks

 

[z.heineman]

Thank you so much. Here is the final code that works. I removed the
control source and used the debugger to modify your code.

Private Sub CheckNum_AfterUpdate()
Dim rst As Object
Dim strCriteria As String

If Not IsNull(Me.CheckNum) Then
strCriteria = "[CheckNum] = """ & Me.[CheckNum] & """"

Set rst = Me.Recordset.Clone
rst.FindFirst strCriteria

If Not rst.NoMatch Then
Me.Bookmark = rst.Bookmark
Else
MsgBox "Check not found", vbInformation, "Warning"
End If
End If

End Sub

Big help, Thanks.