Reject user making same selection twice

[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!

Thanks,
SoggyCashew.....

 

[oxicottin]

Thanks Majp, I figured it out when you said "storing values in some other table and field" and I realized I wasnt. Also thanks Andrzejek for showing us that we can remove text and it will still work...

SELECT FunctionID, RequirementID, FunctionSeqNum, Requirements FROM qry_Requirements
where RequirementID NOT IN (Select RequirementID from tbl_FunctionRequirementsOutput)
ORDER BY FunctionSeqNum;

Thanks,
SoggyCashew.....