How to show items in list box beginning with characters typed by user

[almaroc]

I have a list box which contains a list a customers in the database. i want the list box to show the names of customers that start with the letters entered by the user.

[Seth Schrock]

Check out the the following discussion about a similar question. Advanced Search Form and see if that answers your question. If you have further questions, feel free to ask.

[almaroc]

I Put the code in the TxtPartial_Enter Sub but it didn't work. i did't put anything in the rowsource property of the list box. do i need to set it to strSql. thanks

[Seth Schrock]

You have two options. You could create a query and then select that query as the row source for the listbox or you can type the SQL code into the row source. Either way, you get the same results. The only code that you could put into the textbox is in the after update event that requeries the list box. For example,

Me.{listbox name}.Requery

[almaroc]

Thanks Seth. it worked fine!