Create a Duplicate Record

C

Connie

Hello everyone,
I am using Access 2002 and would like to create a macro that will allow me
to duplicate a record, but only certain fields in the record. Is there a way
to do this, or do I need code or query.
Thanks for any help
Connie
 
S

Steve Schapel

Connie,

I think you need to make an Append Query, which defines the data you
want to add to the new record.

Then, if you want to automate this process, you can use a macro with an
OpenQuery action in order to run the append query.
 
Top