Duplicate Records - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Duplicate Records

Ndubuisi Chibuogwu

4 years 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 @Reply 4 years 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 @Reply 4 years ago
Create a Duplicate Record Add Records Automatically

	Ndubuisi Chibuogwu OP @Reply 4 years 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 @Reply 4 years ago
Please post screenshots and examples. Scrub sensitive data out. To difficult to guess what the problem might be.

	Ndubuisi Chibuogwu OP @Reply 4 years ago

	Ndubuisi Chibuogwu OP @Reply 4 years ago

	Scott Axton @Reply 4 years 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 OP @Reply 4 years 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 OP @Reply 4 years ago

	Ndubuisi Chibuogwu OP @Reply 4 years ago

	Ndubuisi Chibuogwu OP @Reply 4 years ago

	Ndubuisi Chibuogwu OP @Reply 4 years ago

	Ndubuisi Chibuogwu OP @Reply 4 years ago

	Ndubuisi Chibuogwu OP @Reply 4 years 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 @Reply 4 years 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 OP @Reply 4 years 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 in Access Forum.

Next Unseen

New Feature: Comment Live View