How to Fix Duplicate Entry Errors in Access Forms and Tables
Question details
The user is encountering a duplicate-entry error in a Microsoft Access form when trying to copy an existing record.

- 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 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.
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.
Navigate to the Navigation Pane, right-click the table linked to your form (e.g., the Notes table), and select 'Design View'.
Click the 'Indexes' button located in the Show/Hide group on the Table Design ribbon. A dialog box will appear listing all indexed 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.
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.

Adjust the Form Data-Entry Process with AutoNumber
Modify your table design and data-entry process so it automatically generates unique primary key values for new records.
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. Download the Installer: Visit the official WPS Office website and click the free download button for your operating system.
- 2. Install WPS Office: Run the lightweight setup file and follow the straightforward on-screen instructions to complete the installation.
- 3. Open Your Files: Launch WPS Office and open your existing .docx, .xlsx, or .pptx files directly to seamlessly continue your work.

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.




