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?
Sorry, I'm confused.
>Hi, Barbara
>Thank you for responding.
>The combo boxes represent names of a locations, for which there could be 1-4 different names. The user needs to see all the possible options. This allows them to compare and update documentation.
>
>The combo boxes are populated by a parameterized view. This limits the choices of locations.
>
>I have a concern with InteractiveChange(), if a mistake is made choosing the first box the three alternative lists are now gone. Does this make sense? I'm not sure if this is the way to do this but the comboboxes would be nice.
>
>Peter In-Albon
>>You can put code in the InteractiveChange() method of each combo which will update the SQLs for the other three combos. However, I'd like to hear more about what you're trying to do. Do you want to give the user a choice of sources for their data? Why not one combo and an option box with 4 radio buttons? Let the user set the source of the combo.