Re: Preventing duplicate entries

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Open the table in design mode.

Select the field for which you wish no duplicates.

In the lower window, set the Index(ed) property to "Yes, no duplicates".

Save the change.

Be aware that if your table already has duplicates for this field, Access
won't save this change.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Grannash" <Grannash@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CC3FBBDC-EC54-4104-A602-A407F69C1A73@xxxxxxxxxxxxxxxx
I have the same question as Kate, except that all the talk about 'code'
scared me off. :-0 I have no idea about entering code. Is there a "for
dummies" explanation of how I can go about specifying in that a particular
field is not to accept duplicate entires? For example, if you try to
input a
duplicate entry under your primary key, you get an error message. How can
I
make this happen for other fields as well?




.