Duplicating record

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

re: Duplicating record

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.

re: Duplicating record

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

<pietlinden@hotmail.com> wrote in message
news:1120583123.772497.317740@g14g2000cwa.googlegr oups.com...[color=blue]
> 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.
>[/color]