Re: Creating history record

Steve,
I will give this a shot.
The reason I need to wait until they hit the save command is that they have
an undo key if can they change their minds during the update. They could hit
either key. No update, no history.
I'll let you know how things turn out.

Thanks
--
leturner


"Steve Schapel" wrote:

> 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.
>
.