Dynamically filter a list box by text box entry

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form with a text box and list box, and I'm trying to filter the
contents of the list box (reference to a table using 'SELECT ... Like
<textbox> & '*').

It works, but only once the user has entered info into the textbox and then
left the text box. I want the list box to refilter as the user types into the
text box.

I have tried a KeyUp event where the code refocuses the cursor. It works in
terms of updating the listbox, but on returning to the textbox it highlights
the contents and so the second keystroke overwrites the first.

All help very much appreciated.
 
If your ListBox is called lstList and your text box is called txtFilter then
change your SELECT statement in your list box to this

SELECT [TableName].[FieldName] FROM [TableName] WHERE [FieldName] LIKE
txtFilter.Text & "*";

In the On Change event of the txtFilter box put this

lstList.Requery
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Selection from List Box to Text Box 5
use a list box to populate a text box 6
Populating text box using selections from multiselection list box 2
multi selecting items in a list box based on values from a text box 1
CLEAR MORE THAN ONE UNBOUD TEXT BOX BY CLICKING AN ACTION BUTTON 1
Drop-down list box not available in toolbox 4
Calculating a text box 9
unbound text box filter by form on Split Form 1

Back
Top