I've got a picklist under the field "Item".  I need to know how to check if the user is trying to select some Item on the picklist that has been selected previously in a subform.  The tricky part is prior to hitting the "submit" button, nothing is updated to the tables yet.  So how I can check and prompt user that this is a duplicate selection?