New record without Saving Changes?

[ThinWhiteDude]

I have tried to find something like this in the past postings, with no luck, so here goes (and if I missed it I apologize):

I have a form used to add records to a table. I would now like to use that form to make changes to an exisiting record --NOT SAVE THE CHANGES MADE-- but make a copy of that changed record and put it into another table, tblEditedRecords. Then I would have the original record and a table with the edited version of the record.

Is this possible with SQL? And if so, could I get a little help on how to write it? I have done some SQL behind some of the buttons on my forms, but am still a SQL newbie.

I will be grateful for any help.
TWD

 

[sfreeman]

Seems a little, what's the word... off...

Usually, one would want to go ahead and make the changes [update the record], but keep a copy of the prior record BEFORE it was changed. Basically that is keeping a change history or transaction log. If that IS what you want to do, you may find this link helpful:

http://members.iinet.net.au/~allenbrowne/AppAudit.html

Sam_F
"90% of the problem is asking the right question.

 

[ThinWhiteDude]

Sam,

This seems to be what I'm after. Basically, the reason for the process is that a manager is going to commit the changes to the original table at a later date. It looks as though this series of functions will accomplish what I want, given that scenario.

I'll spend this afternoon seeing if I can get this to work for me. Thanks for the help,

TWD