Re: Creating history record

Larry,

You can use an Append Query to put a copy of the existing record into the history table. I guess it would seem logical to me to do this prior to editing?

--
Steve Schapel, Microsoft Access MVP


Larry T. wrote:
I have a form that allows the user to update a record. I have used a command button to perform this function. Now the user wants the before image to be saved to another table for history. I have saved all fields prior to any changes. The problem I now have is using that save information to update the history data base. I would like to have it all done using the save command button. In other words;
save updated record, than save history record using before images. Thanks for any help. 
.