469,090 Members | 1,211 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,090 developers. It's quick & easy.

Avoiding Form Autosave & Microsoft Error on Closing


I'm looking for help when it comes to how to stop a form from autosaving when it is closed and instead use a "save" and and an "exit" button. I've looked online and found tons of code that is supposed to help with this, but I am so code-illiterate that I have no idea what I need to modify in the code to apply it to my specific form.

I need a save button that saves, an exit button that exits without saving any changes, and I'd like to avoid the "You can't save this record at this time. Microsoft Access may have encountered an error while trying to save a record" message that comes up when trying to close with the X button.

I know that it'll be the BeforeUpdate event that needs coded but everything I've tried hasn't worked - one button will work and the other won't or I'll get the "you can't save..." message.

I'm so frustrated!!!

Any help would be greatly appreciated!!!
Dec 7 '16 #1
0 625

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by Renzska | last post: by
1 post views Thread by thomasp | last post: by
2 posts views Thread by Fionnbarr Kennedy | last post: by
2 posts views Thread by Dave | last post: by
3 posts views Thread by Zürcher See | last post: by
reply views Thread by John Swan | last post: by
2 posts views Thread by rdemyan via AccessMonster.com | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.