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

  • Thread starter Council of Community Services
  • Start date
C

Council of Community Services

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

Thanks
 
L

Lynn Trapp

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
[email protected]> wrote in message
news:[email protected]...
 
C

Council of Community Services

Thank you! The response was helpful. I'm adding a combo box at the beginning
of the form to check for duplicate records.
 
Top