I apologize about my tittle I am new to access and would like some help if what I want is possible. I attached my file in a zip access test1.zip
I have a table with info that the column "J" (GE) might have duplicates which is fine, but I would like it to once I scanned the barcode "F" using the combobox and it fills out my form, Access populates the date in column "O" (Validity) in all the rows that match the GE, even though the barcode is not the same so if I scan another different barcode "F" but the same GE example Row 2 and 4, it will pop up and error box warning me that it has been scanned before and give me the options to continue or cancel.
IS something like this possible with Access or should I try Excel instead?
Thanks