If you're only looking for one name, why use 4 combos? You can use the JOIN command (or a series of SQLs) to get a single cursor with a distinct list of all the names in all 4 fields. Or will you need to find "Berkeley" in combo1 sometimes but "Berkeley" in comb2 other times? In other words is any given name found only in one record, one PK at a time?
>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?
>>