By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,480 Members | 3,113 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,480 IT Pros & Developers. It's quick & easy.

Avoiding Form Autosave & Microsoft Error on Closing

P: 1
Hi,

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
Share this question for a faster answer!
Share on Google+

Post your reply

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