Code to stop duplicate names

[hootie318]

I have a table of names and addresses for senior citizens that need help around the holiday season. Each year we enter new names, there are always "new entries" that are names already on the list. I need a way to stop duplicates. My fields are:

FIRSTNAME
LASTNAME
ADDRESS#
STREET
APT
CITY
STATE
ZIP

Is there any code that could tie the first name and last name together and check the table for duplicates?

 

[ColinEssex]

A search would have found this

http://www.access-programmers.co.uk/forums/showthread.php?t=78710

Col

 

[usermj]

A search would have found this

http://www.access-programmers.co.uk/forums/showthread.php?t=78710

Col

Just one more comment on the code in the link above:

Cancel=True or -1 will be required when you set those codes in the events like BeforeUpdated()

Cancel (as Integer) is the argument of that event