[AccessD] Duplicate Record?

Rocky Smolin at Beach Access Software rockysmolin at bchacc.com
Sun Aug 5 19:25:12 CDT 2007


Dear List:
 
I guess this is my weekend for questions.
 
Using DAO I am creating a temp table of emails to be sent.  So I do an
.AddNew and assemble the data in the fields of the new record.  Just before
I .Update, I want to look at the existing records in the recordset and if
the record I've just created is a duplicate I don't want to add the record
so the person only gets one email.  
 
My first idea was to brute force check each field in a FindFirst but there
must be a simpler or more elegant way of doing this.  There are seven fields
to check.

MTIA
 
Rocky
 

 	
	




More information about the AccessD mailing list