As the user add a product in a subform, how do I check, right after the product code has been typed in, if the user has not already typed in the same product in any rows above ?
We frequently have quotes with up to 400 lines in the quote subform... That is why we would like to help the users by telling him that is has already typed in the product he is adding.