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