How do I set up notification of duplicate names in an Access DB?

[dkruger]

I want to be notified when I entered a duplicate name into my DB in Access.

 

[Ofer]

Do you enter Data Via form? or strait into the table?

 

[Arvin Meyer]

I want to be notified when I entered a duplicate name into my DB in

Access.

Check the name by using DLookup or a recordset to see if that name exists in
the table. Both methods are outlined in the help files. Post back if you
need more help.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access