Microsoft Access Forum

Access Forum

Duplicate Records Upload Images Link
Ndubuisi Chibuogwu
3 months ago

Hello Richard. The duplicate record encounters problems when dealing with records containing primary keys e.g. employee ID or student ID. How can one navigate around this please? The objective is to be able to create a duplicate record and make modifications on it that does not alter the original record. Thanks

Adam Schwanz
3 months ago

Just make a second/third/fourth record and link it to the first. Either in a second table (probably easier) or with another ID field in your current table.

Relationships

Scott Axton
3 months ago

Create a Duplicate Record

Add Records Automatically

Ndubuisi Chibuogwu
3 months ago

The problem is the records are 12 in number and the duplicate is applied to a form with a subform holding the records. I tried creating a duplicate button but it duplicates the records in the subform but when I make changes to the duplicate records it still affects the records in the base form/table

Scott Axton
3 months ago

Please post screenshots and examples. Scrub sensitive data out.
To difficult to guess what the problem might be.

Ndubuisi Chibuogwu
3 months ago

Scott Axton
3 months ago

Still need the code. Nothing here shows the properties or events of the duplicate button.
Did you watch the videos I linked above?

Ndubuisi Chibuogwu
3 months ago

I watched the video and used the command wizard selecting record operations and then duplicate records. As for the events I did not use any event.

Ndubuisi Chibuogwu
3 months ago

The last two messages are the actual nested form that is giving me a problem. There are three forms (the main form, subform and a nested form). The duplicate function works but whenever I modify the records on the duplicate copy it still affects the record from the main table

Richard Rost
2 months ago

Hi there. Without digging through your code to figure out where you went wrong, the problem is probably that the new records have a wrong ID somewhere. This is a fairly complicated thing to do, but I cover how to copy a record with all of its child (related) records properly in Access Developer 24.

Ndubuisi Chibuogwu
2 months ago

Ok thank you for the early response. I will watch the Lesson 24 and see how it can help me out.

This thread is now closed. If you wish to comment, start a NEW discussion, below.

Back to Access Forum Comments

Subscribe to Access Forum
Get notifications when this page is updated