Hi all.

I have 5 comboboxes that pull the same list of data. I want all of the comboboxes to dynamically change which items are available in the list.

If a value is selected in a combobox, I don't want that value to be in the list of any of the other comboboxes. How can I do this?

Also, it would be nice if the other comboboxes did not lose their current selection when the other comboboxes have their list altered.

Any ideas?