Macro help

[Mike]

Hi, I created and access database with a subform. I would
like to have that sub-form tables be copied to an archive
or history table in a different location, before they make
any chnages to the data on a daily basis. Ex, they would
enter a new Appoitment date, I would like to save the old
date to the history file before the change. So that I can
refer to it any time I need to either provide reports. I
have created a table using a macro, but when it excutes it
sends the new data to the table instead of the old data.
any ideas on how to make it to where the old data gets
save to the history file instead the new data?

here is what my Macro has in it.

Action
CopyObject
Action Argument for CopyObject
DD: File location
Source Oject type Stored Procedure



save
thanks

 

[Steve Schapel]

Mike

From the information you gave so far, I can't quite follow the method
you are presently using. But I would suggest you set up an Append Query
to add the old data to the history table. If you want to use a macro to
make this happen, the OpenQuery action would be applicable, to run the
Append Query.