Results 1 to 2 of 2
  1. #1
    nick404's Avatar
    nick404 is offline Competent Performer
    Windows 7 32bit Access 2007
    Join Date
    May 2015
    Location
    Wisconsin
    Posts
    352

    VBA for adding new record

    On a form I have a 'save entry' button for a user to press once they are done inputting data. When they click this button I would like the form to proceed to a new record, as this form will most likely be used at the end of the day or at a time when multiple entries will be made. Or at the very least the database will be left open for continual input throughout the day. More likely than not the people inputting will not know they can click on the bottom panel to navigate through records, so the banal save entry button is going to be utilized. I do not know the vba for this and am strangely having a hard time finding it. Thanks!



    Edit: Unless perhaps using a macro would be better..?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,638
    Record entry/edit is committed to table when form/table closes, move to another record, or run code to save.

    Just move to new record row.

    DoCmd.GoToRecord , , acNewRec
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 1
    Last Post: 02-20-2013, 01:30 PM
  2. Adding a new record using VBA
    By acmis in forum Programming
    Replies: 3
    Last Post: 11-07-2012, 01:24 PM
  3. Replies: 6
    Last Post: 08-22-2012, 03:24 AM
  4. Replies: 4
    Last Post: 08-14-2012, 07:14 AM
  5. Replies: 14
    Last Post: 05-25-2012, 02:40 AM

Tags for this Thread

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