Exit forms without saving

[robsworld78]

Yeah you can get rid of those but you need to be careful so I've been told. I haven't run into trouble but apparently it can cause issues because the messages don't get turned back on and you get no warnings anywhere in access.

You need to add

DoCmd.SetWarnings False
before the code that brings a warning then after the code add
DoCmd.SetWarnings True



For extra protection whenever I use this on a form I also add

DoCmd.SetWarnings True

to the "on close" event of the main form and the subform if there is on. This way the warnings are turned back on for sure. If they don't get turned on it can cause problems.

[robsworld78]

Make sure you don't put "DoCmd.SetWarnings False" before the msgbox otherwise if a user hits no then the "DoCmd.SetWarnings True" doesn't get run. Put it right before the run macro code and right after.

[sk88]

Make sure you don't put "DoCmd.SetWarnings False" before the msgbox otherwise if a user hits no then the "DoCmd.SetWarnings True" doesn't get run. Put it right before the run macro code and right after.

Perfecto!!! its working just the way that I have wanted!! Thank you so much!

[robsworld78]

No problem, glad to hear it works, I've been getting lots of help on here and its great I can finally give some back.

[katmomo5]

Hi, did you ever get this to work?