Combo Box visible

[gsbatch1]

RESOLVED!!!!!! Combo Box visible

I have a form with 9 combo boxes of different data. They are all 9 invisible. Depending on which selection is made in a different combo box, then the corresponding 1 of the 9 combo boxes becomes visible with that list of choices. The problem is when I make a choice, and then decide to change the combo box choice to a different one of the 9, the original data I choose is still visible in the new combo box.

tblNetwork
ESPN
CSN
FOX
ETC.

tblESPN
NFL
NHL
MLB
Etc.

tblCSN
Phillies
Eagles
Flyers


I choose ESPN which makes the combo box for tblESPN visible.
Then I choose NFL
I go back and change from ESPN to CSN and the cbo box for tblESPN is now invisible and tblCSN cbo Box is now visible, but NFL is still listed until I click on the drop down arrow for the combo box for tblCSN

How do I make it change back to blank so that a choice has to be made?

 

[John Big Booty]

Rather than have all those combos. I suspect you could do what you are after, with just two combos, But you would make the second combo cascade off the selection made in the first so that only data relevant to selection made in the first is visible in the second.

Check out the link here for a simple explanation of how to set up a cascading combo box set.