Closing a form - problem

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
 
A

Allen Browne

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

close form - parameter request pops up 3
How to prevent form from closing 2
Problem with closing a form using a command button 2
Preventing Form Closing In ACCDE 3
Restore or maximize after closing a form? 3
form closing problem 16
Updateing data when closing forms 3
Closing and open Form whilst linking the correct record being open 1

Top