Search form

[Catherine]

I created a form to find a specific record on a different form. I used the code below. I remember it working in the past and I don't know what I may have changed. Can you tell me why it isn't working? What is the best way to allow a user to select a record to view (e.g. by customer name) on a different form and then jump to that record on that form?

Private Sub cmdSearch_Click()
Dim strName As String

strName = Me.txtName

DoCmd.OpenForm "frmActiveITEXMembers"
DoCmd.FindRecord strName, onlycurrentfield:=acAll
DoCmd.Close acForm, "frmFindITEXMemberHaves", acSaveYes
End Sub