Duplicating record

[John]

Hi

How can I make a copy of a record in the same table via code? Is there a
feature like whole record copy & paste?

Thanks

Regards

 

[Guest]

Open the table, find the record, highlight, and copy.
Click on EDIT- Paste Append.

 

[John]

Via code.

Open the table, find the record, highlight, and copy.
Click on EDIT- Paste Append.

 

[Rick Gittins]

If the table has a primary key and you know it at the time you want to copy
the record you can create a insert statement to run.

Rick

 

[John]

Can I do it without any reference to specific fields, as the fields can
change and I don't want to remember to come back and change the insert query
every time?

Thanks

Regards