Does anyone have any ideas/code to, on each combo box change, update the other combo boxes based on the selections? The combo boxes can be selected in any order.
I am guessing that each time a combo box is changed, all of the combo boxes would be checked to see if not null then filter data based on all the selections. when looping through the combo boxes on the form, how do you store those into variables that I can use for the advanced/autofilter?
It would be easier if the combo boxes had to be selected in a specific order, but it decreases the value of my form tremendously.