Cascaded Multi Select List Box - Query code?

[Torinjr]

Hi All, I have a Form that I want to have a cascading multi select list box. As shown below:





I am having trouble writing a query that updates the second list box "sub contractors" based on the multiple selections from the first list box. I have been able to set up cascaded comboboxes in the past but have never tried with a list box. Can anyone guide me through this please?

[June7]

Never seen this with a multi-select listbox. These are UNBOUND controls?

I think the second listbox will need code that loops through the first listbox and builds filter parameters that can be used with IN operator. Review: http://allenbrowne.com/ser-50.html

[Torinjr]

Yes they are UNBOUND. So this seems reasonably difficult to do, for me anyway. Is there another way that I can get the user to select multiple Sub Contractors based on the multiple Scope/Package selected? This was just the first way that came to mind...

Thanks.

[June7]

If you want to restrict the second listbox RowSource based on selections in first, VBA is only method I know of.

I don't know your data structure, but a single listbox might be able to have a RowSource that has all valid combinations of package/contractors as choices.

[Torinjr]

Yea i think i might just create a single list box to display 2 columns. It will be a longer list but is okay for the amount of data i have at the moment.