MultiSelect List Box/Filter?

[Ellpee]

Hi All. Have a situation where a multiselect list box shows (depending on user's previous choices) all accounts that currently hold a particular stock, or all active accounts, full stop. For a new stock market trade transaction, I want the user to be able to select only the few accounts, likely less than 10, that are relevant to the current transaction.



Thing is, in either case the initial number of items in the list box would be LARGE -- over 100 at best if limited by holdings, conceivably several hundred if not. So, now comes my question. After the user has made the necessary picks, can I do something with code (launched by a button, probably) that would "adjust" what is displayed in the listbox to only selected items, so user can see he/she has indeed selected all the relevant accounts and only those? Looked at properties for the listbox but didn't find a filter property that would work beyond what I could have done with the RowSource property in the first place (at which point I unfortunately had no idea what listed items the user would select). Could I maybe change the SELECT statement using SelectedItems as a criterion, then refresh the listbox?

Help me think through this, please. Until the user makes his/her choices, can see no way to limit the listbox population below those inconveniently large numbers. And I can't think of any way to make those choices without having to weed through big numbers of possible items.

[June7]

Could but then user could not select additional items if they realized they missed something without modifying RowSource again to provide complete list.

Should probably show users picks in another control, perhaps another listbox.

Where are these selections saved to?

[Gicu]

The typical design for this involves two side by side list boxes (Available and Selected) with four command buttons in between (Select, Select All, Unselect and Unselect All) usually with arrows instead of captions showing the direction the selection(s) are going. There are many examples on the web for this, I prefer using some sort of a check box (IsSelected) in the source table and simply requery the two list boxes after the user pushes a button. The trick is to ensure the table is isolated from other users so I use a local front-end table for that.

Cheers,

[Micron]

Suggestion is a common approach. User selects one or more list items from initial listbox, clicks a button to transfer those selected, then some action uses the selected items list.
It's also 'customary' to have buttons to Take All (one button for each direction you want to transfer). It might look something like this

[moke123]

Here's an example custom class picklist.

[Ellpee]

Hmm, useful thoughts. Side-by-Side seems the most reasonable for my situation, though I'll look closer at the ccPickList idea as soon as I have time. For further info, at this juncture list is not stored anywhere; plan is, when selects are "validated," store them in a (CSV) global string variable as they are used at several points later in the procedure via the In() functionality. Thanks to all for inputs so far.

[moke123]

For further info, at this juncture list is not stored anywhere; plan is, when selects are "validated," store them in a (CSV) global string variable as they are used at several points later in the procedure via the In() functionality.

My picklist returns a csv with several options for formatting so it works well when using it with an IN clause.

I made a few small changes and I can no longer edit the above post, so i'm attaching another copy.