Disable AutoSave Subform
By Richard Rost 6 months ago
Disable Automatic Record Saving in a Subform
In this Microsoft Access tutorial we will talk about disabling AutoSave and prompting the user to save changes in records in a subform.
A couple of weeks ago, I released a video called Disable AutoSave where I showed you how to use a Before Update event to ask the user if they want to save changes to the current record. This works perfectly fine for single forms with one record, however a ton of you asked me if there was a way to get this to work with a subform containing continuous forms. The answer is yes, and I will discuss it in this video.
Members will learn how to have the database prompt one time only for any number of edits made to the detail items, not once per item. It involves a lot more code, but it's so worth it.
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!
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 subform, disable blind saves subform, automatic saving of edited records subform, disable automatic saving subform, How do I turn off AutoSave in Access subform
Subscribe to Disable AutoSave Subform
Get notifications when this page is updated