undoing changes to table/form

[raychoy2k]

Another newbie question : )

If I open a form and make one small change in any field, the record is saved to the table. How can I add a command button to undo all changes and not commit the changes to the table? Basically, I want to be able to cancel everything and not add that record to the table.

 

[FoFa]

You have to use a second table, one or the other since access does not support transactions like SqlServer. It does allow you to backout of the current PENDING update, but that is it as far as I know.

 

[George Too]

Any other takers for this question? I have the same situation I want a working solution for.

Thanks,
George

 

[Mile-O]

I'm with Fofa. An intermediary table where the data is stored - with an extra time stamp field. Frm this table you can then append entries to the main table or delete entries from the holding table.

 

[George Too]

That's what I had in mind before but I thought there would be an easier way. I guess I got to listen to the pros.

Thanks,
George

 

[Fornatian]

Another newbie question : )

If I open a form...

I would agree guys if this were a table however wouldn't this just be case of using the beforeupdate event to cancel the update at users request.

If you are talking about backing out of a session's worth of updating where you have edited multiple records then I refer you to the previous responses

 

[Mile-O]

Re: Re: undoing changes to table/form

If you are talking about backing out of a session's worth of updating where you have edited multiple records then I refer you to the previous responses

That's how it read to me.