Undoing data changes on a continuous form

[Guest]

I have a continuos form that the user can update i want to have a 'save
changes' and a 'cancel changes' button on the form

The Me.Undo command only undoes the changes made to the current record

How do I set up a 'cancel changes' button to undo changes to several records
at once.

I've considered copying the records to a temporary table when the form is
loaded and then copying to the main table when the save changes command is
pressed but this seems a little unwieldy. Does anyone have any better ideas?

Thanks

Simon

 

[Rick Brandt]

I have a continuos form that the user can update i want to have a 'save
changes' and a 'cancel changes' button on the form

The Me.Undo command only undoes the changes made to the current record

How do I set up a 'cancel changes' button to undo changes to several records
at once.

I've considered copying the records to a temporary table when the form is
loaded and then copying to the main table when the save changes command is
pressed but this seems a little unwieldy. Does anyone have any better ideas?

The best idea is to convey to your users that edits are saved "as they go" and
to not change anything unless they want the change saved. Otherwise in a
continuous form your idea of using a "work table" is the only option you've got.

If you are concerned about "accidental" changes you can open the form initially
with AllowEdits, AllowDeletions, and AllowAdditions set to False and then
provide a button that toggles those properties to True. This way the user is at
least indicating an intention to change the record before he is allowed to do
so.

 

[Guest]

Shame theres no easier way

Thanks a lot Rick

Simon