Problem Saving Changed Data

[JamesJ]

I'll look into not prompting to save.

Thanks much for your time and effort,
James

Sorry 'bout quitting last night. I got tired.
.
This db is a 2007 Beta This is occurring on all forms.
These forms are split forms (which I like tremendously)
I saved my 2003 db and I'm not getting any errors... whether
I click Yes or No and close the form using the Form's (X), no problem.
btw. Using CmdSaveRecord the error is it was canceled.

Sounds like a bug in the beta then. Sorry, but I have not not done
anything with the beta so I can't help you with that.

A different strategy might be in order. I am personally in the camp of
developers who feel that "Do you want to save your changes?" prompts are
at best unnecessary and at worst very annoying to users. The only time I
have ever used them was when the users (or more likely their manager)
asked me to put them in.

If you are worried about accidental changes then lock the form and provide
an [Edit] button that unlocks it. That way the user is clearly indicating
intent BEFORE making any changes which should eliminate any need to ask
them after they make them. Then simply train users that changes are saved
by default and not to go willy-nilly on the record unless they expect
those changes to stick. Also show them how the <escape> key works.

Another big advantage of this strategy is that it teaches them how Access
actually works. If your apps do a lot of extra hand-holding then they
might very well expect ALL Access apps to work that way.