I've noticed a behaviour in A2007 that doesn't appear in A2003. The
problem is appearing in a native A2007 database and an A2003 database
running in A2007. If I press a command button to delete a record on a
single form using DoCmd.RunCommand acCmdDeleteRecord as the code
behind the button, when I close that form Access asks me if I want to
save the changes to the form.

This only happens if the database is an mdb or accdb. If it has been
compiled into an mde or accde the problem doesn't manifest. Why would
this be happening?

I've seen this a lot in a2007. It does not happen in a .accdr file, by the
way. I had to change lots of code on my close commands, where I first do a
save record, then I do a:

docmd.close acForm, "FormName",acSaveNo

Then the message doesn't appear. However, if you have subforms, you'll get
save messages for the subforms as well. So I made a blank subform, and prior
to the docmd.close statement, I'll put something like:

forms!Customer!subform.sourceobject = "subBlank", where subBlank is the
blank subform. Not sure why access 2007 does this, however.

Andy
"Wayne" <cqdigital (AT) volcanomail (DOT) com> wrote

On Mar 8, 9:11*am, "ARC" <PCES... (AT) PCESoft (DOT) invalid> wrote:
Thanks.