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

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.

•  01. Free Video
•  02. Extended Cut Video - Silver Members
•  Database Download - Gold Members

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Pre-Requisites

• Disable AutoSave: https://599cd.com/DisableAutoSave

Links

• Try it Yourself: https://599cd.com/Try
• Record Locks: https://599cd.com/RecordLocks
• Simple Security: https://599cd.com/SimpleSecurity

Recommended Courses

• Access Developer Courses: https://599cd.com/Developer

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

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 subform, disable blind saves subform, automatic saving of edited records subform, disable automatic saving subform, How do I turn off AutoSave in Access subform