How do I make access ask the user to save the changes?

[Guest]

Hi People,

I read some answers given to questions similar to mine, but I m not satisfied.

Can somenone help me about writing VBA code for asking the user if he/she is
sure to save the record changes made in the form or table?

Thanks a lot!

 

[Douglas J. Steele]

In the form's BeforeUpdate event, ask them. Set the value of Cancel to False
if they don't want to.

 

[Larry Daugherty]

Hi Yilmaz,

Unless you have changed things, a chqnged record is saved when you move off
the current record or when you close the form. Have you tried making
changes, advancing to a new/different record and then stepping back to the
changed record?

HTH