Duplicating record

J

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
 
K

KARL DEWEY

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

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
 
J

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
 
Top