Subform filter with multiple text box

[paramesium]

Hi all,

I wanted to build a dynamic search form using text box instead of the common combo box type.

After searching throughout the forum, I found an example that used the combo box and the searching portion of the code is as followed:

If Nz(Me.txtID, "") > "" Then
    If Len(Nz(strFilter)) > 0 Then strFilter = strFilter & " And "
[COLOR="red"]    strFilter = strFilter & "CategoryID = '" & Me.txtID & "'"[/COLOR]
    bFilter = True
    End If

As I am very new to ms Access and VBA, I have no Idea how to insert (Like "*" & Me.txtID & "*") into the code to make the dynamic search using text box possible.

Please advice, thanks in advance!

Regards,
Jack

 

[Mihail]

I'm not as new as you are to Access but still I have not founded a solution to your question.
Seems that is not possible to insert a "Like" function via VBA.
But... maybe someone else know a way.