Searching For a text field

[Stang02GT]

Hello,

I want to be able to have a user search for a customer by their name. I have "name" feild in my DB and have a text box on a form where the user can enter the customers name and click a "Search" button to execute the search.


I have done this before by searching for a number. But i think I have to change something with the code because i am searching for text and not a number.

Private Sub Command27_Click()
   If IsNull(Text32) = False Then
      Me.Recordset.FindFirst "[Name]"=' & Text32
      Me!Text32 = Null
      If Me.Recordset.NoMatch Then
         MsgBox "No record found", vbOKOnly + vbInformation, "Sorry"
            Me!Text32 = Null
      End If
   End If
End Sub

I think my problem lies i the bolded area. Maybe i need to change the " "'s or something like that.

[missinglinq]

Try replacing

Me.Recordset.FindFirst "[Name]"=' & Text32

with

Me.Recordset.FindFirst "[Name] = '" & Me![Text32] & "'"

Linq ;0)>