Create a duplicate record

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Scott - 17 Nov 2007 06:31 GMT

I use a form to input the data into the table. From time to time, I need to
create a duplicate record from previous records or just completed new
record. I saw the previous articles here but most of them to copy the last
record to a new record. However, I need to highlight the desired record and
copy to a new record. Any guidance and example are appreciated.

Thanks,

Scott

Reply to this Message

Allen Browne - 17 Nov 2007 08:46 GMT

Here's one that lets you duplicate the record in a form, as well as any
related records in the subform:
http://allenbrowne.com/ser-57.html

Just ignore the part about the subform, and use the rest.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I use a form to input the data into the table. From time to time, I need
>to create a duplicate record from previous records or just completed new
>record. I saw the previous articles here but most of them to copy the last
>record to a new record. However, I need to highlight the desired record
>and copy to a new record. Any guidance and example are appreciated.

Reply to this Message