Check for Name Duplicates when entering new records

[ApexData]

No point in reinventing the wheel!

-I'm looking to create a popup dialog that prompts for FirstName MI
Lastname.
-Checks and reports duplicates.
-And offers the user an option to continue or cancel.

I know this must be a very common aspect of systems managing names, and
know that many creative interfaces must have been built. I was
wondering if any samples or examples exists at sites that I can
experiment with. Or, suggestions that will make for a good performing
smooth/intuitive interface.

Thankyou
Greg

[Allen Browne]

Use the BeforeUpate event procedure of the *form* (not controls) to check
for a duplicate.

Use DLookup(). If you need help, see:
Getting a value from a table: DLookup()
at:
http://allenbrowne.com/casu-07.html

If the DLookup() finds a match, use MsgBox() to ask the user what to do. To
cancel the entry:
Cancel = True
Me.Undo

--
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.

<Ap******@gmail.comwrote in message
news:11**********************@a75g2000cwd.googlegr oups.com...

No point in reinventing the wheel!

-I'm looking to create a popup dialog that prompts for FirstName MI
Lastname.
-Checks and reports duplicates.
-And offers the user an option to continue or cancel.

I know this must be a very common aspect of systems managing names, and
know that many creative interfaces must have been built. I was
wondering if any samples or examples exists at sites that I can
experiment with. Or, suggestions that will make for a good performing
smooth/intuitive interface.

Thankyou
Greg