Synchronized Combo Boxes

[Guest]

Alright I was successful creating two combo boxes that are now synchronized.
Thank you...I referenced Microsoft help "Basing one combo box on another.

Now I want to add a few more and synchronize them all together. How do I do
this? What if I want to skip the first combo box and jump to the 2nd, 3rd,
etc. How can I select a value in the 2nd box first without the 1st box?

 

[Brian Bastl]

the same principles apply, no matter how many combos you add.

Brian

 

[Guest]

I thought it was that simple to. However, I created a new problem. If I
skip the 1st combo box selection, the next (2nd, 3rd, etc.) combo box will
not populate a list. I can't choose from a list in any of my combo boxes
Unless I select each combo box in order.

Sometimes I know what I need in the 3rd or 4th combo box and would rather
save time and start my "drill-down" at the combo box that applies.

Basically, I want my combo boxes populated with list until I make a choice.
Once I make a choice in any combo boxes, it would be nice if the rest of the
combo boxes would requery and populate a new list for each combo box. is
this realistic?