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?
In Access 2016, how can we copy records from one field to another in the same table, with a macro?
Microsoft Access
Last Comment
Gilberto Sanches
ASKER CERTIFIED SOLUTION
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.
Yes. Study my simple and fast code in this old question: Clone Record
ASKER
Copying should happen when the user clicks on a button.
A update query made it possible. It works.
Thanks Ryan
A update query made it possible. It works.
Thanks Ryan
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.