Duplicate Existing Record in Microsoft Access

In this video, I will show you how to create a button to duplicate a record in your Microsoft Access forms.

Tanya from St. Paul, Minnesota (a Platinum Member) asks: I need a button that can duplicate (copy) an entire record into a new record. We need this to duplicate a product where almost everything is the same except a couple of fields, which we can edit manually.

Members

Members will learn how to create a duplicate but only copy specified fields over to the new record.

Sara from Riverside, California (a Platinum Member) asks: Is it possible to create a duplicate button like in your video, however only copy a couple of the fields to the new record. Most of the data will be different except for a couple of fields.

•  Extended Cut Video - Silver
•  Database Download - Gold

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!

Links

• Intro to VBA: https://599cd.com/VBA

Suggested Course

• Learn how to copy a record and all related child records (such as an order with all of its details) in Access Developer 24: https://599cd.com/ACD24

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

microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Use Control Wizards, How do you duplicate a record in Access, Can you copy a record in Access, Duplicating Records in Access, ms access duplicate record, Duplicate the record in form and subform, access duplicate record and subrecords, ms access duplicate record with subform, Record Operations, Duplicate Record, Control Wizards Not Working