Avoiding entering duplicate values

[djclntn]

The title of this thread is weak; I didn't know how to phrase it. I have this Form (or a Record) of Vehicles for sale which has a number of fields. Two fields ‘StockNumber’ & ‘VINNnumber are set as PK because I cannot have duplicates. The issue that I’m having is when I enter in a new Vehicles Info, if it (the vehicle) has already been entered it doesn’t tell me until I try to go to another (or New) Record. There must be a way (or is there a way) that when I enter in a New vehicle’s StockNumber as soon as I click to the next field if that particular StockNumber is already in the Table Access will tell me right away? Any suggestions will be greatly appreciated!

[pbaldy]

You can use a DCount() with the appropriate criteria to see if a duplicate exists already.

DLookup Usage Samples