Create a Duplicate of an Existing Record in Access

Sometimes you want to make a duplicate copy of a record. Perhaps you're entering products and you have two products are very similar except for a few details. You can duplicate the record and just change the different fields. This video will teach you how to do it with a single click.

New Version

There is a new version of this video available here:

• Duplicate Record

Members

There is no Extended Cut for this video.

Links

Command Button Wizard

If you want to duplicate a record that has related child records, such as an Order with Order Details, then you'll need some VBA programming. I cover this in Access Developer 24.

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.