Notifying a user when changing data.

[Guest]

Is it possible to notify a user that they are about to change data in a
specific record/control permanently, in order to prevent them from possibly
losing information that they should not have changed.

I'm only aware of the edit undo last change in Access to revert to what was
there previously in a control, but after that it seems data is changed
permanently.

Is it possible (in a simple manner) to achieve the above. Help much
appreciated.
Thank-you.

 

[MA]

Is it possible to notify a user that they are about to change data in
a specific record/control permanently, in order to prevent them from
possibly losing information that they should not have changed.

I'm only aware of the edit undo last change in Access to revert to
what was there previously in a control, but after that it seems data
is changed permanently.

Is it possible (in a simple manner) to achieve the above. Help much
appreciated.
Thank-you.

You have to create a clone table where you archive the old record
On form_beforeupdate if the record is stil edit and not a newone you can
save all the oldvalue of the field

--
_ _
Ciao
MAssimiliano Amendola www.accessgroup.it
Cisa - Conferenza Italiana per Sviluppatori Access
Info: www.donkarl.com/it

 

[Rick B]

Just put code in the Form's BEFORE UPDATE event that asks the user if they
wish to continue or abort. Then either end the sub, or cancel the update.