I am creating a form and need to create multi-select list boxes.

For example:

I have Category and under that is:

Hardware
Software
Services
Accessories
Other

The user may want something from four of the choices. I need it set up that once they select their choice they can then select from Type - depending on each Category and then Make and Model. Any help in this would be most grateful.

Thanks

Welcome to UA!!

Sounds like you want cascading combo boxes. Check out the "Cascading Combo Boxes Database" sample on Candace Tripp's Sample Site.

Hope this helps...

Thanks a co-worker told me about this website. I have looked at the cascading Combo Boxes and unfortunately they are not what I want. The multi-select will allow me to select several items from each list. I have tried doing it but am doing something wrong.

Thanks for pointing me to Candace site. There are a couple of things in there that are very useful to me.

I think what you need to do is create SQL on the fly with multipel criteria written to a string.

So your SQL to populate the second list becomes a bit like this:

strWHERE1 = Me.ListBox.Column(0)
Next Item
strWHERE2 = Me.ListBox.Column(0)
...
strSQL = strSQL & strWHERE 1 & "Or " & strWHERE2 and so forth...

Or am I barking up the wrong tree?