VBA so I cant make same selection in combo box

[oxicottin]

Hello I have a combo box [cboRejectLotNumber] on a continious form [fsub_RejectedData] and I cant have the same selection used more than once. What VBA can I add that will stop the user and give a message and send them back to the combo box? Thanks!

[jonh]

In the table, change the indexed property of the field to "Yes (No Duplicates)" and handle the error in your vba.