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

  • Thread starter Yılmaz KandiÅŸ
  • Start date
Y

Yılmaz Kandiş

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!
 
D

Douglas J. Steele

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

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
 
Top