Filter multiple fields with one search criteria on form

[hlock]

I have a form with 2 fields - Name1 and Name2. I want to be able to enter
search criteria in my unbound text box and have it check both fields and
return records if the text is in either Name1 OR Name2. Currently, I have it
working for just one field.

If Not IsNull(Me.txtfiltername) Then
strWhere = strWhere & "([Name1] Like ""*" & Me.txtfiltername & "*"")
AND "
End If

How do I get it to search on Name2 as well? Thanks in advance.

 

[Kipp Woodard]

If Not IsNull(Me.txtfiltername) Then
strWhere = strWhere & "([Name1] Like ""*" & Me.txtfiltername & "*"" Or
[Name2] Like ""*" & Me.txtfiltername & "*"") AND "
End If

 

[Douglas J. Steele]

The quotes don't look quite right.


--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

If Not IsNull(Me.txtfiltername) Then
strWhere = strWhere & "([Name1] Like ""*" & Me.txtfiltername & "*"" Or
[Name2] Like ""*" & Me.txtfiltername & "*"") AND "
End If

I have a form with 2 fields - Name1 and Name2. I want to be able to
enter
search criteria in my unbound text box and have it check both fields and
return records if the text is in either Name1 OR Name2. Currently, I
have it
working for just one field.

If Not IsNull(Me.txtfiltername) Then
strWhere = strWhere & "([Name1] Like ""*" & Me.txtfiltername &
"*"")
AND "
End If

How do I get it to search on Name2 as well? Thanks in advance.

 

[hlock]

Works perfect. Thank you for all of your help!!

The quotes don't look quite right.


--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

If Not IsNull(Me.txtfiltername) Then
strWhere = strWhere & "([Name1] Like ""*" & Me.txtfiltername & "*"" Or
[Name2] Like ""*" & Me.txtfiltername & "*"") AND "
End If

I have a form with 2 fields - Name1 and Name2. I want to be able to
enter
search criteria in my unbound text box and have it check both fields and
return records if the text is in either Name1 OR Name2. Currently, I
have it
working for just one field.

If Not IsNull(Me.txtfiltername) Then
strWhere = strWhere & "([Name1] Like ""*" & Me.txtfiltername &
"*"")
AND "
End If

How do I get it to search on Name2 as well? Thanks in advance.