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