Create a Duplicate Record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top