Huge MultiSelect Listbox Question ..

[mtompkins]

I have a huge multiselect list box that has choices by a unique identifier in the form of #-###-####

ex. 3-411-2323

There are thousands of these records and it takes a fair bit of scrolling for the user to get to the records he needs.

To that end - I was wondering if I could create a "move to" box, where as the user entered digits, the list box would move closer to that records.

For example into the box the user would enter 5-4 and the listbox would scroll down to where the 5's are.

It wouldn't select of limit so it wouldn't be a query. It would scroll the listbox.

Any thoughts?

 

[lars7]

Have you tried a combo box?.

 

[fneily]

I created a letter button form for a company. They had alot of clients, so instead of scrolling or trying to figure out how to spell a name, they just clicked a letter button and then in the listbox only those clients with that first letter appeared. Then they double clicked on the client they wanted to putll up the info. You could do the same with the first number. If you want me to send you an example, go to thread702-563868 , scroll down and you'll see how to contact me.

 

[mtompkins]

Hi Lars, thanks for yours.

Unfortunately a combo box doesn't suit the purpose. The need to select mulitple choices exists. Additionally the large scrolling would still be evident.

Hi fneily, thanks for yours.

Unfortunately I need all choices always active. In fact as they are "used" we have the ability to make them become inactive which removes them (filters) from this large multiselect. The multiselect by its use needs to be able to select those records that will be passed on to the query (report) and can be anywhere withing the data domain.

 

[PHV]

The combo (with AutoExpand=True and SAME RowSource than the ListBox) may be used as a front end to the huge multiselect listbox.
A starting point in the combo AfterUpdate event:
Me![name of ListBox].Selected(Me![name of comboBox].ListIndex) = True

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[lars7]

hi mtompkins,
The reason I suggested the combo box is that you can type into it so much less "large scrolling", try PHV's idea it works great.

 

[mtompkins]

Sorry Gents -

EXACTLY what I was looking for!

Thank you both.