How can I use multiple text box for filtering?

[Jaik]

In my form there are customer Id text box and customer sub Id text box.


So I want to make them as filters and currently I have something like this

WHERE (((History.[CustomerID]) Like "*" & [Forms]![FORM_CUST]![CustomerIDT] & "*") and ((History.CustomerSubID) Like "*" & [Forms]![FORM_CUST]![CustomerSubIDT] & "*"));

However, seems like only Customer ID is working and if I type anything into the CustomerSubID text box, it ignores the input.
Is there any way to troubleshoot this issue?


Thank you!

[aytee111]

It is usually easier to filter the form:
Me.Filter="CustomerID=" & me!CustomerID & " AND CustomerSubID=" & me!CustomerSubID
Me.FilterOn=True
Me.Requery