Closing Access Submits Form Data Unintentionally

[Paroxuno]

Hello,
I have a form linked to a Sharepoint list which works great, the only problem I have is that if you close out of Access (using the X on Access itself), it submits any partial data that has been entered into the form. In the form itself I have submit and close buttons and the x for the form is disabled. The submit buttons within the form have code tied to them to validate that the needed fields have been entered.

I have no code tied to any 'on close' event for the form. How do I prevent any data from being recorded when someone closes Access using the x button?
I do not believe I am able to use an 'on close' event either, since one of my buttons submits the data, closes the form, and opens a new one.



​​​​​​​Thank you.

[CJ_London]

Just a suggestion

in the form module create a public Boolean called say doUpdate

in the form open event put: doUpdate=False

in the submit button click event put: doUpdate=True

in the form beforeupdate event put: Cancel=not doUpdate

[John_G]

Another way to do this is to open the form as modal, meaning that while the form is open, Access cannot be closed. If fact, while a modal form is open, clicking anywhere outside of it will have no effect.

If you are using DoCmd.OpenForm to open the form, it looks like this:

DoCmd.OpenForm "formname", , , , , acDialog

If you are opening it from the navigation pane, set both the Modal and Popup properties to Yes