copy current record to new record

[er_manojbisht]

How to copy current record to new record and set focus to primary key field

[Rainlover]

You can't copy the current record to a new record as there would be a voilation because of a duplicate Primary key.

You could however use an append Query to append some of the fields to a new record.