Joe- Check out the BeforeUpdate event in frmContacts in this sample database:
ftp://ftp.viescas.com/Download/Contacts2000.zip It performs a check for possible duplicate name using SoundEx. John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of eliotchs Sent: Thursday, December 08, 2005 9:17 AM To: [email protected] Subject: [ms_access] ? on Checking Duplicates.. Hi, I'm looking for some samples for checking for duplicates. I have an SSN field set to be unique, but sometimes do not get the SSN I'd like to setup a listbox for show up with client of the same name so users cab check to see if they are the same person they are trying to enter.. Thanks In advance Joe Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/KIlPFB/vlQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
