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:
[ Ссылка ]
PRE-REQUISITES:
Intro to VBA: [ Ссылка ]
If Then: [ Ссылка ]
MsgBox: [ Ссылка ]
Before Update: [ Ссылка ]
LINKS:
Save Button: [ Ссылка ]
RECOMMENDED COURSE:
Access Developer 24: [ Ссылка ]
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: [ Ссылка ]
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: [ Ссылка ]
or My Site: [ Ссылка ]
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: [ Ссылка ]
Blank Template: [ Ссылка ]
Contact Management: [ Ссылка ]
Order Entry & Invoicing: [ Ссылка ]
More Access Templates: [ Ссылка ]
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: [ Ссылка ]
$1 Access Level 2: [ Ссылка ]
Donate to my Tip Jar: [ Ссылка ]
Get on my Mailing List: [ Ссылка ]
Contact Me: [ Ссылка ]
TechHelp: [ Ссылка ]
Consulting Help: [ Ссылка ]
Twitter: [ Ссылка ]
[ Ссылка ]
[ Ссылка ]
[ Ссылка ]
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
![](https://i.ytimg.com/vi/LpFpacVWUp8/maxresdefault.jpg)