Assuming that the form shows all the records in your your table and you want to jump to the chosen record, and that the Primary Key is a number ...
Code:
Private Sub yourCommandButton_Click()
With Me.RecordSetClone
.FindFirst "yourPrimaryKey = " & val(me.yourTextBox & vbNullString)
If .NoMatch Then
MsgBox "Record not found", vbInformation + vbOkOnly
Else
Me.Bookmark = .Bookmark
Endif
End With
End Sub
I prefer to use criteria in my form's RecordSource query. This allows me to use the same technique whether my BE is Jet/ACE or SQL Server/Oracle/DB2/etc.
Change the query to include criteria:
Select ...
From ...
Where MyField = Forms!frmMyForm!txtMySearchField;
Then in the AfterUpdate event of the text box, you need to requery the form.
Me.Requery
Limiting the bound recordset to the minimum number of records is good practice for client server applications since it minimizes network traffic. It does prevent you from using .FindFirst or Filter though.