I have a list box that uses a WHERE to filter on a text box’s value. I’d like to update the listbox every time a character is entered in the text box but the WHERE does not see the value in the text box until the update occurs, ie when the focus moves from the text box.
How can I update the value of the text box on the Change event so the list box shows changes?