3 combo boxes with same Names of Engineers

[MarkV]

All 3 combo boxes have the same table of names. I have LeadEng1 in one combo box, BackUpEng1 in second combo box, and BackUpEng2 in third combo box.
How can I say if the user clicks on the name MARK in LeadEng1 that it cannot be entered into the other two combo boxes? No names can be the same.
Thank You
Mark

[CJ_London]

something like this in the 2nd combobox on enter event

me.combo2.rowsource="SELECT ID, Name FROM myTable WHERE ID<>" & combo1

sure you can work out the third

[MarkV]

Thank YOU so much, I will try it