Results 1 to 3 of 3
  1. #1
    thexxvi is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    May 2015
    Posts
    63

    Prevent Unfinished Records from Saving in Navigation Form

    Hello,



    I have a simple navigation form with a few sub forms that users will be filling out. At this point, if a user starts to fill out Form A but decides midway through completing that form that they want to click another tab in the navigation form, the unfinished record saves from Form A. I want to prevent any unfinished records from saving to the database. How can this be accomplished?

    Thank you in advance for you help!

  2. #2
    John_G is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    Do your data validation in the Before Update event of the form. If the data is incomplete, you can cancel the event to prevent navigation to another record.

  3. #3
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2013 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    When a user clicks outside of the subform the OnExit even triggers and the update to the table has already happened, there is no way to stop that from happening.

    You could make your subform unbound and force the user to click on a "Save" button, then when they clicked outside of the form you could ask them whether they want to save or not. To save you would run an update query.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 08-14-2015, 12:01 PM
  2. Replies: 4
    Last Post: 07-20-2015, 07:11 AM
  3. Replies: 0
    Last Post: 10-28-2012, 12:20 PM
  4. Problems with unfinished job reminder form
    By robertmarkdudley95 in forum Programming
    Replies: 4
    Last Post: 02-27-2012, 07:31 AM
  5. Prevent Saving of Form
    By bburton in forum Access
    Replies: 4
    Last Post: 02-25-2011, 09:26 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums