Can't get filter to filter by 'contains' (1 Viewer)

[gojets1721]

So I've got a form that I'm using to allow the user to input info into some fields and then filter down a form.

One field is an employee name field and I can't seem to code it in a way that filters by 'contains' rather than 'equals. (I.e. if a user types in 'john', I would want fields with 'john smith' to populate in the report. But right now, you have to type 'john smith' in full to get the applicable entries to populate on the form)

Here is the code:

    If Not IsNull(frm!txtEmployeeName) Then
        If strWhere <> "" Then
         strWhere = strWhere & " AND "
        End If
        strWhere = strWhere & "[EmployeeName] LIKE '" & frm!txtEmployeeName & "'"
    End If

Any suggestions?

 

[CJ_London]

you need to include asterix

strWhere = strWhere & "[EmployeeName] LIKE '*" & frm!txtEmployeeName & "*'"

 

[June7]

You should research use of wildcard characters with LIKE operator.

 

[strive4peace]

hi @templeowls

this phrase doesn't have any wildcards, which is why it behaves like =
LIKE '" & frm!txtEmployeeName & "'"

correct to be:

LIKE '*" & frm!txtEmployeeName & "*'"

so it begins and ends with a wilcard ~

oh, and I see that is exactly what @CJ_London suggested too!