Announcement

Collapse
No announcement yet.

Closing Access Submits Form Data (Not Wanted)

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Closing Access Submits Form Data (Not Wanted)



    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.

  • #2
    Look at this link. I think that this may be the solution you need. http://www.fmsinc.com/microsoftacces...eventclose.asp

    It prevents closing of the Database itself using the X button
    Alan

    Did you debug your code first? http://www.cpearson.com/excel/DebuggingVBA.aspx
    FORUM RULES----->http://www.ozgrid.com/forum/announcement.php?f=8

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

    Comment


    • #3


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

      Comment

      Working...
      X