2 Combo boxes link to same table remove what was already selected

[Awagenhurst]

I don't know if I titled it properly but I'll explain it the best way I can.

I have 2 combo boxes that are connected to the same table because i want the user to have the option to pick from the same table more than once. I already have it built and it look great however if I pick Sofa from combobox1 sofa is listed in combobox2 and I was wonder if that can be changed. So if user picks sofa in combobox1 sofa will not appear in combobox2.

Thank you

 

[Ranman256]

the query for combo2
select * from table where [option] <> forms!frmMyForm!combo1