Entering Data in a form

Hi,

I'm trying to create a database for a church that consists of some of the
following fields: Autonumber, Fname, Lname, address, date of birth, email,
phone,
My question: Is there a way that I can get a warning message (for duplicated
records) when I use a form to enter the records? Because, I cannot use their
SSN, or any other unique number that identfies each person. So I need to know
if I ever enter a person with the same Fname, Lname, Address... I know that
there might be multiple people with the same Lname, and Fname, but not
address. But at the same time, there might be multiple people with different
names with the same address (family) Or, do you have a better solution to
this?

Thanks.

John

If you are comfortable with VBA code, you could use the BeforeUpdate event
procedure of the *form* (not control) to look for duplicates.

You could use DLookup(), using the Fname, Lname, and Address fields in the
criteria (3rd string.) However, there could be multiple duplicates, so it's
a bit more involved than that.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"John" wrote in message
...
I'm trying to create a database for a church that consists of some of the
following fields: Autonumber, Fname, Lname, address, date of birth, email,
phone,
My question: Is there a way that I can get a warning message (for
duplicated
records) when I use a form to enter the records? Because, I cannot use
their
SSN, or any other unique number that identfies each person. So I need to
know
if I ever enter a person with the same Fname, Lname, Address... I know
that
there might be multiple people with the same Lname, and Fname, but not
address. But at the same time, there might be multiple people with
different
names with the same address (family) Or, do you have a better solution to
this?

Thanks.

John