how to set auto-complete in the name field to prevent dup entries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to set up an auto complete function in the name fields to
prevent duplicate records?

Thanks
 
No, it's not and you probably don't want to do that. It's always possible to
have 2 (or more) John Smith's and you would need a way to enter both of
them. Instead, in the BeforeUpdate event of your data entry form, check for
the existence of a given name and give the user the opportunity to save that
duplicate value or not.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html


"Council of Community Services" <Council of Community
(e-mail address removed)> wrote in message
news:[email protected]...
 
Thank you! The response was helpful. I'm adding a combo box at the beginning
of the form to check for duplicate records.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Auto Matching Duplicates? 0
Prevent duplicate groups of records in a table 1
The next Grand Theft Auto title has been officially announced 0
Simple Access Project - Almost There Just Need Some Help... 2
Auto Complete field 1
Auto Fill in table 0
Prevent Duplicate Form Entries 0
Preventing Dups for 2 fields 2

Back
Top