Others

How to Fix Duplicate Entry Errors in Access Forms and Tables

Aamir Naveed AkramAamir Naveed Akram Oct 29, 2026 869 views

Question details

The user is encountering a duplicate-entry error in a Microsoft Access form when trying to copy an existing record.

How to Fix Duplicate Entry Errors in Microsoft Access Forms
Product
Microsoft Access
Device & OS
not provided
Scenario
Copying a record displayed in an Access form to quickly create a new entry.
Observed behavior
A duplicate-entry error is triggered because the copied record violates a primary key or another unique index in the underlying table, preventing the record from being saved.
Before you start

Before modifying your database, verify which specific table your Access form is linked to and ensure you have administrative permissions to modify the table's design and index properties.

Solution 1Recommended

Review Unique Indexes and Update Copied Records

Identify fields marked as unique in the table's design view to prevent copied records from violating index rules.

When you copy a record displayed in a form, Access attempts to create a new row in the underlying table using the exact same data. If the table enforces unique values (like a primary key), this direct duplication will fail.

To resolve this, you must identify which fields require unique values and ensure they are updated before the new record is saved.

1
Open Table Design View

Navigate to the Navigation Pane, right-click the table linked to your form (e.g., the Notes table), and select 'Design View'.

2
Check the Indexes

Click the 'Indexes' button located in the Show/Hide group on the Table Design ribbon. A dialog box will appear listing all indexed fields.

3
Identify Unique Fields

Review the list and look for any field or combination of fields where the 'Unique' property is set to 'Yes'. Note these field names.

4
Modify the Copied Data

Return to your form view. When you copy and paste a record, immediately change the values in the fields you identified as unique (including the primary key) to new, non-duplicating values before attempting to save the record.

Review Unique Indexes and Update Copied Records
Understanding Form Copies: Copying a record displayed in a form creates a new record in the underlying table, not a new form. This is why table-level constraints and unique index rules immediately apply.
Free Microsoft Office alternative

Need a Lightweight Alternative for Your Office Tasks?

While WPS Office does not include a direct database replacement for Microsoft Access, it offers a powerful, free, and highly compatible suite for your documents, spreadsheets, and presentations. Enjoy a lightweight application that handles Microsoft Word, Excel, and PowerPoint files seamlessly.

  1. 1. Download the Installer: Visit the official WPS Office website and click the free download button for your operating system.
  2. 2. Install WPS Office: Run the lightweight setup file and follow the straightforward on-screen instructions to complete the installation.
  3. 3. Open Your Files: Launch WPS Office and open your existing .docx, .xlsx, or .pptx files directly to seamlessly continue your work.
Highly compatible with Microsoft Office formats including Word, Excel, and PowerPoint.Completely free to use for your essential document editing needs.Familiar user interface ensuring a seamless migration from Microsoft Office.Lightweight design that runs smoothly and opens files quickly even on older devices.
microsoft office alternative - wps office

Frequently Asked Questions

Why do I get a duplicate entry error when copying a record in an Access form?

This error occurs because the record you copied contains a primary key or another field with a unique index. When you paste it, the new record attempts to save with the exact same unique value, which violates the database's strict duplication rules.

Does copying an Access form create a new form or a new table record?

Copying a record while viewing a form does not duplicate the form itself. Instead, it creates a new row (record) in the underlying table connected to that form. The table's data constraints apply immediately to this new row.

How do I find which fields are marked as unique in my Access table?

You can find this by opening your table in Design View and clicking the 'Indexes' button on the Table Design ribbon. Look through the list of indexes for any fields where the 'Unique' column is set to 'Yes'.

Can I automate primary key generation when copying records?

Yes, you can automate this by setting your primary key field's data type to 'AutoNumber' in the table design. If you are copying records using VBA or macros, you should also ensure your code clears the old primary key field before saving, allowing Access to generate a new unique ID automatically.