How do you duplicate a record

[Danny]

I remember this command was established in dBase with "set carry on", so
when you added a new record, the last record would be copied.

Is there a command that will let you duplicate the current record you are
on - in code?

Basically I need something that will copy the record, and then I can modify
a few fields in this record.

Thanks

[Salad]

Danny wrote:

I remember this command was established in dBase with "set carry on", so
when you added a new record, the last record would be copied.

Is there a command that will let you duplicate the current record you are
on - in code?

Basically I need something that will copy the record, and then I can modify
a few fields in this record.

Thanks

Let's say the last record was ID = 15. Create an append query to append
a new record from the record with id = 15.

That'd be the easiest way.