Query by form using "like"

[TimTDP]

On a form I have a list box with the following recordset:

SELECT tblCustomer.CustomerID, tblCustomer.CustomerName
FROM tblCustomer
WHERE (((tblCustomer.CustomerName) Like [Forms]![Form1]![txtCompanyName] & "*"))
ORDER BY tblCustomer.CustomerName;

Also on the form I have a text box called "txtCompanyName"
The On Change event is: Me.List0.Requery

What I want is to filter the list box as characters are entered into the text box.

For example, if the user enters Bar into the text box, all customer names beginning with Bar will be displayed in the list box.

But it does not work!

any suggestions on why not?

Thanks

 

[essaytee]

Try this:

SELECT tblCustomer.CustomerID, tblCustomer.CustomerName
FROM tblCustomer
WHERE (((tblCustomer.CustomerName) Like [Forms]![Form1]![txtCompanyName][B][COLOR="Red"].[Text][/COLOR][/B] & "*"))
ORDER BY tblCustomer.CustomerName;

Steve.

 

[TimTDP]

Perfect. Thank you