Multiple Listboxs

[Stika]

Hi,



Currently I have a combobox which populates a list box based on the selection of the combobox.

I was wondering if it was possible to have a multi selection listbox where I can select and populate the 2nd listbox based on the values I select in the first list box?

Ill give you my example
Combobox - Select A Carrier here

Listbox - Populated with all the orders for the carrier selected in Combobox

What I would Like to do
Listbox1 - Select more then 1 Carrier

Listbox 2 - Populate with all the orders from Carriers selected in Listbox 1

Is it possible?

Im using access 2010 btw

[pbaldy]

It's possible, but a little more complicated. You can adapt this to build an SQL string for the second listbox.

http://www.baldyweb.com/multiselect.htm

[Stika]

Am I able to do it without having to save the selected items to a table?

[pbaldy]

Sure; the method posted does not save the selected items. It simply builds the WHERE portion of an SQL string.