You have to also run the requery command on every combo box or it won't work and you'll still see what you're terming duplicates. As to your other post I have no clue what you're trying to do in this table or what your end result is so I don't really know what to tell you.
in the ON EXIT property of each of your combo boxes you're going to have to requery all the other combo boxes on your form and your have to take out the <> marks in my query I use those to denote where there's variable name that I don't know that you would have to substitute so in your case (using your posted query) you'd have:
Code:
SELECT QryEmpName.EmpFullName, QryEmpName.Emp1, QryEmpName.Emp2, QryEmpName.Emp3, QryEmpName.Emp4, QryEmpName.Emp5, QryEmpName.Emp6, QryEmpName.Emp7, QryEmpName.Emp8, QryEmpName.Emp9, QryEmpName.Emp10, QryEmpName.Emp11, QryEmpName.Emp12 FROM QryEmpName ORDER BY QryEmpName.EmpFullName WHERE (EmpID <> forms!FrmBatch2b!EmpID2 AND
EmpID <> forms!FrmBatch2b!empID3 AND
EmpID <> forms!FrmBatch2b!empID4 AND
EmpID <> forms!FrmBatch2b!empID5 AND
EmpID <> forms!FrmBatch2b!empID6 AND
EmpID <> forms!FrmBatch2b!empID7 AND
EmpID <> forms!FrmBatch2b!empID8 AND
EmpID <> forms!FrmBatch2b!empID9 AND
EmpID <> forms!FrmBatch2b!empID10 AND
EmpID <> forms!FrmBatch2b!empID11 AND
EmpID <> forms!FrmBatch2b!empID12 AND)
and in the ON EXIT property of your EMPID1 field you'd have to have
me.empid2.requery
me.empid3.requery
...
me.empid12.requery