How to Add a Save Button to Your Access Forms

Access automatically saves records to the underlying table whenever you move from record to record, or close a form. However, sometimes people want to click a save button to feel good about themselves. In this video, I'll show you how to create one.

Suggested Course

• FREE Access Beginner Level 1

Save Record

A few people have asked me why I use Form Operations > Refresh Form Data instead of Record Operations > Save Record. Honestly, it's because I forgot about Save Record. I never use the Command Button Wizard unless I'm teaching a class. I always just make a button and put one line of code in it: Me.Refresh. So that's why my brain was leaning towards Refresh Form Data. Both work exactly the same.

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, #fasttips, save button, floppy disk button, dirty, dirty record, refresh, save record