form should not auto save changes untill i say "yes" to them

[Guest]

form should not directly write in the main database(auto update) while we
chaning the record.untill we say "yes" to it. if we say "no" the changes,
form should have the original recoed in the database.

 

[Guest]

hi,
if the form is bound then you will have to unbind it and
do the update with code.

 

[Van T. Dinh]

You can use the Form_BeforeUpdate Event to ask the user if
he/she wants to save the change. If the user says yes,
let the update proceeds normally. If the use says no,
cancel the update.

HTH
Van T. Dinh
MVP (Access)