Prevent duplicates

[Guest]

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

 

[Guest]

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

 

[Guest]

Ok.

Thank you.
an

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