Updating a list based on text input box

[mbemis]

I am working on a phone book database and need some help. I have a list box on my form which is driven by a querry. Also on the form I have a text box such that you can type in the name with an event update on change to update the list box. But for some reason I can not get the list to update based on the input to the text box. If you open the querry and enter the criteria, then the querry will update. But when I do it on the form I can not get the data in the text box to drive the list box. I have attached a sample database and appreciate any help.

Thanks,
Mike

 

[Moniker]

The description doesn't make any sense, and the after update event is just requerying the listbox, not selecting anything in it.

Are you trying to be able to type in a name and then find it in the listbox and then select it? If so, then you would use the input on the textbox to search the query that the listbox is based on, and then use ListIndex and ItemData to select the appropriate item.

Again, though, your description and the provided sample are apples and oranges here.

 

[mbemis]

Update explantion

I am not trying to select any data in the list box, just simply trying to find an entry by typing in a name. I would like it to update the list after each letter enterend into the text box. Example:

Text box entry: B
updated list:
Baker, John

Beaver, Ronald
Bemis, Edward
Bemis, Michael
Brown, Nathan

Text box enty: Be
updated list:
Beaver, Ronald
Bemis, Edward
Bemis, Michael


Text box entry: Bem
updated list:
Bemis, Edward
Bemis, Michael

If you open only the querry then it will ask for an input, which then it will show the querry with the required results. But when you run it from the form, then it will not update the querry when you change the textbox and it also does not update the listbox on the form.

I hope this explains what I am looking for a bit better. If you have any other questions, let me know.

Thanks again for any help.
Mike