No announcement yet.

Closing Access Submits Form Data (Not Wanted)

  • Filter
  • Time
  • Show
Clear All
new posts

  • Closing Access Submits Form Data (Not Wanted)

    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.

  • #2
    Look at this link. I think that this may be the solution you need.

    It prevents closing of the Database itself using the X button

    Did you debug your code first?
    FORUM RULES----->

    If someone has helped you, say "thank you" by clicking on the Like Button.


    • #3

      Exactly what I was looking for in a detailed, well explained article. Thank you!