Avatar of Gilberto Sanches
Gilberto Sanches
Flag for Suriname asked on

Copy records with Macro to other fields

Hi Expert,

In Access 2016, how can we copy records from one field to another in the same table, with a macro?
Microsoft Access

Avatar of undefined
Last Comment
Gilberto Sanches

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Ryan Chong

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Scott McDaniel (EE MVE )

When/How would you do this? When the user clicks a button, or when some event occurs?


In general, it's a bad idea to duplicate data like this, unless you're copying over a record to set "default" values - that is, you will "duplicate" the data, but you're going to update one or more fields after you duplicate.

Gustav Brock

Yes. Study my simple and fast code in this old question: Clone Record

Gilberto Sanches

ASKER
Copying should happen when the user clicks on a button.

A update query made it possible. It works.

Thanks Ryan
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck