Wow! Thanks so much to all of you for the help. It looks like adding the directory where the DB lives to the "Trust center" has allowed to event code to fire each time now and this case is closed. Thanks again!

thanks for quick replies, i guess i should give up on access 2007, but kind of a pain dealing with work station upgrades, i tried saving in 2003 format without success but only with 2007 client, i'll try full 2003 tomorrow, just seems like really simple VB should just work in 2007.

Hi I have a simple one table, one form MS Access 2007 DB. I want to have the data entry person verify their changes to a record before closing the form or moving to the next record only if any changes were made. I copied some VB code from MS KnowledgeBase (Article ID: 197103 ACC2000: How to Prompt User to Save Changes to Record in a Form for Access 2000) that works perfectly, but only one time. When I close the DB and reopen, the code no longer...