Prevent duplicates

A

an

Hi!

I have a small form to add new records with the fields:

NIdentific (Number)
Name (Text)
DtRecord (Date)

I would like to create a msgbox to prevent duplicates NIdentific when write
a new NIdentific if it already to exist.

Thanks in advance.
an
 
C

Chefjay22

In design view of the tbl, select the field and go to the bottom to general
settings... Under "Index" select "Yes (No Duplicates)"

Good Luck.

Jason
 
A

an

Ok.

Thank you.
an

Chefjay22 said:
In design view of the tbl, select the field and go to the bottom to general
settings... Under "Index" select "Yes (No Duplicates)"

Good Luck.

Jason
Click to expand...
 
Top