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:
599cd.com/DisableAutoSave
PRE-REQUISITES:
Intro to VBA: 599cd.com/IntroVBA
If Then: 599cd.com/IfThen
MsgBox: 599cd.com/MsgBox
Before Update: 599cd.com/BeforeUpdate
LINKS:
Save Button: 599cd.com/SaveButton
RECOMMENDED COURSE:
Access Developer 24: 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: 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:
RUclips: / @599cd
or My Site: 599cd.com/THMember
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Contacts
Order Entry & Invoicing: 599cd.com/Invoicing
More Access Templates: 599cd.com/AccessTemplates
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/TechHelp
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.org/wiki/Microso...
products.office.com/en-us/access
microsoft.com/en-us/microsoft...
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

[@599CD]

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: 599cd.com/DisableAutoSaveSubform
(Available Tue Apr 4, 2023 - Members can watch NOW)

[@Ivanostefanelli.]

You are amazing thank you very much. Your way of conducting the arguments is pleasant.
I'm watching your channel and just looked at your site. I'm looking for the one that will serve me the most among your proposals. Thanks again.

[@599CD]

Welcome

[@syedabbas201]

Excellent

[@599CD]

Thanks

[@n.a.8687]

thaaaaaaaaaaaanks brother

[@stephenbeswick2163]

This is an excellent video I am watching this video in hospital many thanks Steve b

[@599CD]

Glad you got home safe

[@josephmessina5689]

Hi Richard. I saw your video about disable auto save in Microsoft access. I was going to ask about that cause I know access automatically saves changes! I’m always watching your videos on access.

[@599CD]

Thanks

[@MrAshfaqahmed]

Hi Richard, I have been following you from long time, You are awesome in Access VBA Programming, I had tried this approach and it worked fine for me when I started VBA Programming. But here is little issue if we have a subform in the main form if you cancle the saving on main form but on the subfrom if we put this code it will prompt many messages both from main and subform, it will create some type of conflicts, so what is the approach for both main and sub form. If I want to cancle a new record to create on main form but it will insert su from data to table.

[@599CD]

I'll be talking about this in an upcoming video. Lots of people have asked.

[@jairomancilla250]

Hi, if I want to add a DB field that was not saved before, where can I put it, since the program saves it through a DoCmd.RunCommand acCmdSaveRecord?

[@rudraverma5970]

Great SIR👌 But I have one problem I use it in invoice bill form but it will not work in because there is one sub form in that form , sub form of item details..

[@599CD]

I don't understand your question.

[@ristanto8888]

What if for a form with sub form? Dillema for ms access "trap"

[@599CD]

Coming up in a future video

[@8deepak8sharma8]

sir i have created a form in this i have written event in current form and before update form to stop auto save now the problem comes that when i move on sub form while working in main form all of main form data is cleared


[@onpassive2441]

Thank you.. I follow your channel and benefit, but is it possible for you to do translation in the videos that you provide? Sometimes I cannot understand some of the sentences, especially when you speak quickly.. Thank you again.

[@599CD]

Well, since I only speak English, there's no way for me to translate it myself. And I don't receive enough requests to justify paying for translations, so this would have to be something you do on your own. I believe there are software applications out there that automatically translate videos for you using AI. But again, I haven't really looked into it because I haven't had a need to do it, so give it a quick search on the Google machine and see what you find, and let me know.

[@nursetiadi81]

hi, Richard. so, how to handle that error? 8:48

[@599CD]

599cd.com/ask

[@SanshineReiGalindo]

hi is subform already available.

[@599CD]

Disable AutoSave Subform: 599cd.com/DisableAutoSaveSubform

[@599CD]

Disable AutoSave Subform: 599cd.com/DisableAutoSaveSubform