Hi:
I am using a textbox to dynamically limit results in a list box (list2). I want the listbox to requery after every letter typed into the text box. I tried to do this using the OnChange event of my textbox and I can almost get it to work. I used the Me.list2.requery followed by Me.refresh commands to get the appropriate selections to appear in the listbox. But the refresh command creates a problem because it highlights the textbox entry, so if I try to type the next letter, it overwrites everything instead of adding a character. Is there some code to deselect everything in the textbox that I can type in?
Thanks for your help in advance.
I am using a textbox to dynamically limit results in a list box (list2). I want the listbox to requery after every letter typed into the text box. I tried to do this using the OnChange event of my textbox and I can almost get it to work. I used the Me.list2.requery followed by Me.refresh commands to get the appropriate selections to appear in the listbox. But the refresh command creates a problem because it highlights the textbox entry, so if I try to type the next letter, it overwrites everything instead of adding a character. Is there some code to deselect everything in the textbox that I can type in?
Thanks for your help in advance.