How to Disable Automatic Record Saving in Microsoft Access

In this Microsoft Access video tutorial I will teach you how to prevent Access from automatically saving records when you make edits unless you specifically allow it. When the user tries to leave the record, we will allow three different options. They can either accept the changes and save the record, not save the changes, or cancel leaving the record and return to editing. Once again, we'll take a look at how ChatGPT tackles this problem. LEARN MORE: https://599cd.com/DisableAutoSave PRE-REQUISITES: Intro to VBA: https://599cd.com/IntroVBA If Then: https://599cd.com/IfThen MsgBox: https://599cd.com/MsgBox Before Update: https://599cd.com/BeforeUpdate LINKS: Save Button: https://599cd.com/SaveButton RECOMMENDED COURSE: Access Developer 24: https://599cd.com/ACD24 SUBFORMS? Tons of people have asked me if it's possible to do this in a subform with continuous forms and multiple child records. The answer is yes. I cover that here: Disable AutoSave Subform: https://599cd.com/DisableAutoSaveSubform THE CODE: Private Sub Form_BeforeUpdate(Cancel As Integer) Dim Response Response = MsgBox("Save changes. Are you sure? (Yes=Save Changes, " & _ No=Abort Changes, Cancel=Continue Editing)", vbYesNoCancel + vbQuestion, "Save Changes?") If Response = vbYes Then Cancel = False ElseIf Response = vbNo Then Cancel = False Me.Undo Else Cancel = True End If End Sub BECOME A MEMBER: YouTube: https://youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join or My Site: https://599cd.com/THMember FREE TEMPLATE DOWNLOADS: TechHelp Free Templates: https://599cd.com/THFree Blank Template: https://599cd.com/Blank Contact Management: https://599cd.com/Contacts Order Entry & Invoicing: https://599cd.com/Invoicing More Access Templates: https://599cd.com/AccessTemplates ADDITIONAL RESOURCES: FREE Access Beginner Level 1: https://599cd.com/Free1 $1 Access Level 2: https://599cd.com/1Dollar Donate to my Tip Jar: https://599cd.com/TipJar Get on my Mailing List: https://599cd.com/YTML Contact Me: https://599cd.com/Contact TechHelp: https://599cd.com/TechHelp Consulting Help: https://599cd.com/DevNet Twitter: https://twitter.com/LearningAccess https://en.wikipedia.org/wiki/Microsoft_Access https://products.office.com/en-us/access https://microsoft.com/en-us/microsoft-365/blog/access/ KEYWORDS: access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, autosave, disable blind saves, automatic saving of edited records, disable automatic saving, How do I turn off AutoSave in Access