Combo Boxes

[MarkV]

I have 3 Combo Boxes that have the same people in it as a drop down. Say I put first Combo Box as David. Now I want the next two combo boxes to NOT allow the user to put David in any of them. They cant put same person in either CB 2 or 3. Thank You.

[orange]

It seems that after a selection in combo1 is made, you have to change the rowsource of Combo2
to not include/remove David

eg revise the rowsource for cb2 (and cb3 use same code)
" Select yourName from yourtable where yourname <> '" & me.combo1 "'"

[MarkV]

Thank You so Much.....