HOW DO I COPY TEXT FROM ONE FIELD TO ANOTHER USING A MACRO?

G

Gillian

I am new to Access and have created a basic database containing development
product information. I want to copy text from a "current status" field to a
"history" field using an "update" button to run a macro so I can add new
details to each product.
 
B

BruceM

Details should be in their own table. That table is on the "many" side of a
one-to-many relationship with the main table. You could add a yes/no field
to designate the information as history rather than current, or maybe you
could just order the data chronologically.
 
Top