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.