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

[pietlinden]

Umm... create a select query that grabs the record you want. Probably
point it to the open form.
Turn that into an append query so that it appends to the same table
that it's looking at.
In your form, bookmark your record (if you want to return to it), shut
off your warnings, run query, then turn warnings on again, and return
to bookmark. (or you could go to the last record...)

Sorry. Access != Excel.

[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

<pi********@hotmail.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...

Umm... create a select query that grabs the record you want. Probably
point it to the open form.
Turn that into an append query so that it appends to the same table
that it's looking at.
In your form, bookmark your record (if you want to return to it), shut
off your warnings, run query, then turn warnings on again, and return
to bookmark. (or you could go to the last record...)

Sorry. Access != Excel.