Undo command

[Glynn]

Undo appears to only 'undo' the last change entry.
I have a Continuous form that calls up previously entered data for edit.

If, however, the user makes a number of edits to the data in various
records, the UNDO command only undoes the very last change - whereas I want
the UNDO to undo all the changes the user may have made to the various
records .

How can I UNDO all the changes to the records in the Continous form.

I may go mad in the interim, but would appreciate any help.

 

[John Spencer]

There is no built in way of doing this.

One method that you can employ is to use a set of parallel tables that
you populate with the records you are editing and edit the parallel set.
When the user finishes the edits they can press a button to initiate
code that will copy the changes from the working table(s) to the master
table(s).

If you want to UNDO your code would reload the master records into the
working table(s).

If you cancel, you just clear the working table(s) and don't bother to
make the updates to the master table(s)

This is not a trivial process. It takes a bit of VBA coding to handle
and it gets really complex if your database is multi-user and users are
liable to be working on the same set of records simultaneously.



'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

 

[moshe via AccessMonster.com]

I Think Of An Idea That You Should Pass A String At The Begining Of Your
Forms Code.
dim Field1, Field2, ...
in The On Enter Event Of Each Field Enter Something Like Field1 =
Yourfieldname
and If The User Clicks The Undo Key The String Should Be Passed Back To The
Field
i'm Not At The Computer Now So I Didn't Test It But I'll Have To Make
Something Similer For One Of My Customer And He You Need It Just Reply And
I'll Bed Here A Copy Of My Code