Question Extreme Validation

[mitch_johnson]

hello, is there a way in access of telling you if there is another identical record to the one you have just entered eg- if i enter a model number in the model number field of: 11004 if there is already a record with that model number it gives me a warning message or stops me entering the data thanks

 

[jsv2002]

The most simple way is to set the value in the table you have created the form from, in the table select the field you don't want duplicates in then look in bottom left hand and select Indexed Yes (no duplicates) there are various other ways but that should do what you need.

good luck John