Multi-select list box - find a record/find as you type

[r15gsy]

I am using a multi-select listbox which works fine and passes the selections to some code.

The listbox has a long list of data and I need to be able to quickly find an item.

How can I use a combo box to search, as it doesn't work with a multi-select list box.

If I click on the list I can search by 1st letter (i.e. B), is there a way to find as you type (i.e. Battery)

Thanks..

 

[TheAceMan1]

How are ya r15gsy . . .

Use a [blue]combobox[/blue] instead, and be sure to set its [blue]Auto Expand[/blue] property to [blue]Yes[/blue]. You'll get find as you type functionality . . .

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[r15gsy]

Hi TheAceMan

Thanks for the reply, but i need multi select, hence listbox.

 

[PWise]

try this create a combobox with the same rowsource as the list and int theafter update of the ombobox

Me.Listbox.Selected(Me.Combobox.ListIndex) = True

 

[r15gsy]

pwise

That sounds ace, will give it a go.

 

[r15gsy]

pwise

Tried it and it sort of works.

It highlights the selection in the list, but does not jump the list to that row.

 

[MajP]

faq702-6304
faq702-6295
faq702-4398