Hi,

I have 4 comboboxes on a form.

In Form_Initialize, i am adding 4 values to each of them. These values
are same for all the 4 combos.

Dim strEPIC() As String
ReDim strEPIC(4)

strEPIC(0) = "Empathy"
strEPIC(1) = "Persuasion"
strEPIC(2) = "Impact"
strEPIC(3) = "Communication"

For i = 0 To 3
Me.ComboBox1.AddItem strEPIC(i)

Me.ComboBox2.AddItem strEPIC(i)

Me.ComboBox3.AddItem strEPIC(i)

Next i



So my question is:
--------------------------
If i select a value in the 1st combo, the remaining 3 should not show
the value and only allow user to select the remaining 3 values in the
other combos. similarly, if i select a value in 2nd combo, the
remaining 2 combos should not show the selected items in the previous
2 combos i.e. Exclude those values... So each combobox should
eventually have only 1 unique value selected in it and should show
remaining 3 items in its list. e.g.

combobox 1
-----------------
selected value: Empathy
remaining items in it: Persuasion, Impact, Communication

combobox 2
-----------------
selected value: Impact
remaining items in it: Empathy, Persuasion, Communication

combobox 3
-----------------
selected value: Persuasion
remaining items in it: Empathy, Impact, Communication

combobox 4
-----------------
selected value: Communication
remaining items in it: Empathy, Impact, Persuasion


How can i achieve this?