Results 1 to 5 of 5
  1. #1
    Freddie81 is offline Competent Performer
    Windows 10 Access 2013 64bit
    Join Date
    Mar 2018
    Posts
    149

    Stopping record autosave when using a form


    Hello Guys,

    Probably a dumb question but I want to know how do I stop Access from automatically savinf the record after I press enter on the last field? I need the user to click submit to save it and not automatically save it and go to the new record.........

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Please provide more context for I need the user to click submit. Tell readers about the applicationin plain, simple terms.

  3. #3
    Freddie81 is offline Competent Performer
    Windows 10 Access 2013 64bit
    Join Date
    Mar 2018
    Posts
    149
    My apologies

    The databas does invoicing and quotations. The form Im working on currently is for data entry into the products table. The user clicks a button to create a new entry and then needs to enter the data ( Code, description and price). I ned the form to stop the auto sav of the record after enter is presse don the last field. So far i cheated a bit, I addded a check box so it gets the focus after price is entered.
    When the user clicks submit is hould only save the record incase it isnt completed.

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

  5. #5
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,016
    Simplest way is to ask the user if they want to save the Record:
    Code:
    Private Sub Form_BeforeUpdate(Cancel As Integer)
    
     If MsgBox("Would You Like To Save This New Record?", vbQuestion + vbYesNo + vbDefaultButton1, "Save This New Record Yes or No???") = vbNo Then
       Me.Undo
      End If
    
    End Sub

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

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

Similar Threads

  1. Tabular form - disabling autosave
    By Jishnu Surendran in forum Access
    Replies: 2
    Last Post: 02-28-2018, 10:56 PM
  2. Counting full textboxes to autosave records
    By NightWalker in forum Programming
    Replies: 4
    Last Post: 04-21-2017, 03:58 PM
  3. Stopping duplicate entry in a field on a form
    By coach32 in forum Modules
    Replies: 7
    Last Post: 08-02-2016, 07:41 PM
  4. Access Autosave
    By danny232 in forum Access
    Replies: 1
    Last Post: 08-06-2011, 02:24 PM
  5. stopping a form from saving records
    By LAazsx in forum Forms
    Replies: 4
    Last Post: 12-09-2010, 05:48 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