Set Access so it doesn't save always

[projecttoday]

My Access 2007 is saving form changes on exiting design view without prompting or giving me a chance to back out of my changes. Anybody know how to set this so it won't do that?

 

[boblarson]

It would appear that you might have done a DoCmd.SetWarnings False somewhere and in your testing it failed to get to the part to set it back (or you forgot to include code to do so). So, go to the VBA Window and to the Immediate Window and type (or copy this):

DoCmd.SetWarnings True

and then hit enter

If that doesn't help, then try doing a DECOMPILE on your database (but save a copy first just in case something goes wrong during that decompile).

 

[gemma-the-husky]

my first thought as well, Bob.

I found a long while ago, that if you change the setwarnings in code, you have to change it back again in code, as the options option (if you will) no longer seems to have any effect.

For the OP - you have to be careful about error handling - if your normal code resets warnings, but you get an error, then your error handler needs to reset the setwarnings status also. Same thing if you break into code either with ctrl-break, or with a unhandled error. In the latter case, you need a little process to reset it, as Bob said.