Closing a form - problem

  • Thread starter Thread starter Paul Doree
  • Start date Start date
P

Paul Doree

Can anyone tell me why, if I close a form using the X box at the top right
hand corner, the database table validation kicks in with warnings because I
haven't filled in some required fields However, if I close the same form
under the same circumstances via a close button (using docmd.close), no
warnings appear and the record is not saved - not good practice for end
users!

Yours (frustrated)

Paul
 
Paul, I agree with your frustration.

This has to be one of the worst bugs in Access, where is SILENTLY loses your
entry if you close the form when the record cannot be saved (e.g. required
field missing.) For a program that is supposed to save by default, just
losing people's data is totally unacceptable IHMO, but I cannot get MS to
fix this data-loss bug.

Once you know about the bug, it is easy enough to work around it: you must
explicitly save the record whenever you use the Close action/method on a
bound form. But this is crazy that 13 years after Access was first released,
it still has the same bug, unfixed.

More info:
http://allenbrowne.com/bug-01.html
 
Back
Top