Save the project, then run it. Enter a valid customer ID, like 'bonap' or 'tortu' in the text box,
then click the command button.

Using ' like ' As a Comparison Operator

You can also use like
as a comparison operator. Use an asterisk in the criteria string to find
one or more occurrences of a value. For example, "state like 'M*'" matches Maine and Massachusetts. You can also use
leading and trailing asterisks to find a substring. For example, "state like '*as*'" matches Alaska, Arkansas,
and Massachusetts.

Asterisks can be used only at the end of a criteria string, or together at
both the beginning and end of a criteria string, as shown above. You cannot use
the asterisk as a leading wildcard ('*str'), or embedded wildcard ('s*r').

In the project described here you can use this value
in the string variable strCriteria:

""CustomerID like " & "'" & txtCriteria.Text & "'"" .

Save the project, then run it. Enter a value like b* or bo* in the text box,
then click the command button.