Textbox Change Event

[highandwild]

I am developing a form whereby the user types a single character or a sequence of characters into textbox and a query WHERE clause is compiled upon each character being entered.

The query is the Row Source of a listbox which I requery upon each change in the text box contents.

In the Change event I cannot access the new contents of the textbox until focus moves to another control and then back to the textbox. This is not how I expect this event to work.

Anybody know what I am doing wrong?

Thanks

 

[pbaldy]

In the change event you have to use the .Text property of the textbox.

 

[highandwild]

Thanks for your speedy reply.

I've already implemenented it and it works fine.

 

[pbaldy]

Happy to help!