Need help with VB search "Like" code

[pikoy]

Trying to create a code that will search a word contained in a field...

see code below: What am I missing? It returns blank.

         ' If Name
    If Nz(Me.Mname) <> "" Then
        'Add it to the predicate - exact match
        strWhere = strWhere & " AND " & "USERS.USER_NAME LIKE ' * " & Me.Mname & " * '"
    End If

 

[Alc]

Too many spaces around the * I think.
Try

 ' If Name
    If Nz(Me.Mname) <> "" Then
        'Add it to the predicate - exact match
        strWhere = strWhere & " AND USERS.USER_NAME LIKE '*" & Me.Mname & "*'"
    End If

[/QUOTE]

 

[pikoy]

you are awesome!!! that fixed the issue....

 

[Alc]

Glad to help. Could you flag the thread as 'solved', in case anyone else is looking for the same thing.