Look for duplications

[Craft]

When I go to add new contact people in my database I have to search to see if this person is already in my database so that I don't get duplications. Is there a way to go to add new records and then when I type in the last name it automatic checks for duplications and pops up the results. If there is a duplication I would like to click on the name and go to that record otherwise go back to adding new record. I enter thousands of names a day and this would save alot of time. I work for a non profit company so we can't afford expense programs. Can someone help?

 

[AlanS]

In the OnUpdate event procedure for the last name text box, put code (using DAO) to find a record with the same last name; if none is found, exit the procedure and proceed normally; if one is found, have it display a new modal form containing a list box showing all the matching records; allow the user to either cancel that form and return to the original form, or double-click on a list box entry; in the list box's OnDblClick property event procedure, cancel the current record entry on the first form, then move it to the selected record, then close the modal form.