hello, i have a continuous form for now i can search just one field with this code
is there anyway to search 4 fields at the time from txt_Search
Code:
Dim strFilter As String
If Len(Trim(Me.txt_Search.Value & vbNullString)) > 0 Then
strFilter = "Clientname Like '*" & Replace(Me.txt_Search.Value, "'", "''") & "*'"
Me.Filter = strFilter
Me.FilterOn = True
Me.txt_Search.SetFocus
Me.txt_Search.Value = ""
Else
Me.FilterOn = False
Me.txt_Search.SetFocus
Me.txt_Search.Value = ""
End If
is there anyway to search 4 fields at the time from txt_Search