Query from Multiple List Boxes

[Gee]

I'm trying a different angle.
Say a user clicks 2 selections in Manub (a multi choice list box to choose a manufacturer) and 3 selections in Segub (another multi choice list box to choose the Seg. Only the Segs with the Manufacturer chosen show up in the Segub list box). I need to then run a query that has the data for all rows which includes those Manufacturers and Segs.
Both are unbound listboxes.
I added a button to run "CascadeQry" and put
[Forms]![CascadeModelFrm]![Manub] in the Manufacturer Criteria of the Query and
[Forms]![CascadeModelFrm]![Segub] in the Seg Criteria of the Query.


It is returning a blank.

Any suggestions?

[Rod]

First you must understand how a multiselect listbox works. There is a property called ItemsSelected that refers to a VBA collection. Rather than try to describe it myself here is the official blurb.

---
The ItemsSelected collection is unlike other collections in that it is a collection of Variants rather than of objects. Each Variant is an integer index referring to a selected row in a list box or combo box.
Use the ItemsSelected collection in conjunction with the Column property or the ItemData property to retrieve data from selected rows in a list box or combo box. You can list the ItemsSelected collection by using the For Each...Next statement.

---

To interpret, this means that there is collection of row numbers that have been selected. You now have to examine each of the selected rows and extract the data value you want. In your case this will be a key to a manufacturer or a seg (whatever that is). Usually you set up a listbox with the primary key in column 0 but hidden.

As you retrieve each primary key you must insert it into a comma delimited string suitable for use with the SQL 'In' construct. Here's an example of a typical SQL 'Where' clause:

... Where Manub In(123,456,789) And Seg In(34,65,89) ...

Obviously all this extraction and formatting has to be done in VBA. Are you comfortable with VBA?