Data not updated warning on Form?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If a form is cancelled or closed without all boxes complete the data is not
written to the table. Can I design a warning message box saying "Data not
updated" in these circumstances?
 
If you close the form using the X at the right of the form's title bar, when
the record cannot be saved, you receive a message telling you so.

If you use the Close action (in a macro) or method (in VBA code), you
receive no message. The workaround is to get your command button to
explicitly save the record first.

Details in article:
Losing data when you close a form
at:
http://allenbrowne.com/bug-01.html
 
Back
Top