Close form without saving the data back to the table

[JCtheEUC]

I have seen this post in other threads but have not seen any real answers. If you know of one please point me in the right direction.

Issue:
I have a form in Access that user will enter information in and post it back to the table. Currently if the they hit the close button it posts the incomplete data back to the table. I don't want that to happen. Idealy if they hit the close button it would simply close and not post back.

Any help would be greatly appreciated.

Thanks!

 

[jackd]

I have seen this post in other threads but have not seen any real answers. If you know of one please point me in the right direction.

Issue:
I have a form in Access that user will enter information in and post it back to the table. Currently if the they hit the close button it posts the incomplete data back to the table. I don't want that to happen. Idealy if they hit the close button it would simply close and not post back.

Any help would be greatly appreciated.

Thanks!

I'm not sure how you tell if the form has been completed properly, but
Me.undo might work if they have not yet moved off the form and caused an
update.
I think your mechanism to know that complete data has been entered is a key part of this issue.


Here is a link, via a google search, that may be useful.
http://en.allexperts.com/q/Using-MS-Access-1440/Saving-Data-Form.htm

 

[Haybus]

Make all fields "must fill" fields and tell the enter'er on the form that if all fields are not completed no data will be saved. Also upon closing have a message box open with that message and give them the option to close the message and go back to the form.

 

[boblarson]

Use the Form's BEFORE UPDATE event and check to see if all of your controls are filled out (the ones you want for a complete record) and if not issue a

Cancel = True
Me.Undo