Macro for duplicate record check

[NeedHelpWithAccess]

Hello,

I want to check for duplicate records AFTER the customers "Last Name" is
entered into my form. I tried doing this with a macro, but can't make it
work. Any help is appreciated! I want the employee entering the information
to be able to type in the last name, have the database search for any
duplicate records, and then have the database present the duplicate records
and ask the employee if they wish to continue or cancel their entry.

 

[Steve Schapel]

Make a Query with this in the Criteria of the LastName column...
[Forms]![NameOfYourForm]![LastName]
Make another form based on this query, probably a continuous view form.
Then, on the AfterUpdate event of the LastName textbox, put a macro
using the OpenForm action to open this form, which will then show all
existing records with the same LastName as the one just entered.