Each combo represents a name of a location, those names are given by four different people. All four names are stored in one record. Now the problem is, the name may or may not be listed in each box but will be listed in one of them. So, if a user looks for the option in box1, its not there, boom, interactive change your done.

What I'm thinking is, a blank selection could perform a revert of sorts or When() method could perform a reset.

Would something like that work? Should I stick with the SQL rather than Array?

Peter

>Yes, using the InteractiveChange() WILL update the other combos - but I thought that was what you wanted. You have 4 combos with 4 DIFFERENT lists and the user makes a choice in from 1 to 4? Then when do you want the combos updated? After choices are made in all 4?
>