Apr 25 2006, 06:55 AM
I am creating a form and need to create multi-select list boxes.
I have Category and under that is:
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.
Apr 25 2006, 07:08 AM
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...
Apr 25 2006, 07:21 AM
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.
Apr 25 2006, 08:05 AM
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)
strWHERE2 = Me.ListBox.Column(0)
strSQL = strSQL & strWHERE 1 & "Or " & strWHERE2 and so forth...
Or am I barking up the wrong tree?
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here