HELP! How do use LIKE in unbound text box?

[ges]

I have the query as follow:
WHERE (((tblAccounts.a_FileType)='Arden') AND ((tblAccounts.a_BillName) Like
"Psych%"))

I have unbound textbox, the value in text box = the value in tblAccounts.
a_BillName

In VBA when I use following code it work:
((tblAccounts.a_BillName) = " & """" & txtbox & """" & ")) "

But it has to be exact name. How do I use LIKE in the above query (such as
LIKE "Psych%") ?

Thanks in advance for any input.

B.rgds,
Ges

 

[Allen Browne]

Try:
strWhere = "[a_BillName] Like """ & Me.txtbox & """%"

Explanation of the quote marks:
Quotation marks within quotes
at:
http://allenbrowne.com/casu-17.html

You may need * rather than % as the wildcard.