Results 1 to 3 of 3
  1. #1
    Starmo is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Jun 2018
    Posts
    43

    Form, enter new record

    Hello peoples!
    I have a form over which I enter the data in the table. Each time I open a form, it shows the first record, so I have to move to the new entry.
    How do I set the form to open an empty so that I can immediately enter a new record?

    Thanks!

  2. #2
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    Put this in the Load Form Event

    Code:
    Private Sub Form_Load()
    DoCmd.GoToRecord , , acNewRec
    ' Set the focus to the appropriate control on this line.
    End Sub

  3. #3
    Starmo is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Jun 2018
    Posts
    43
    Thanks, it works fine!

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

Similar Threads

  1. Replies: 6
    Last Post: 02-12-2017, 02:05 AM
  2. Form Entry (Enter a quanity of record)
    By spartanx117 in forum Forms
    Replies: 3
    Last Post: 10-03-2013, 01:54 PM
  3. Form auto enter field on new record click
    By Traceyann in forum Forms
    Replies: 3
    Last Post: 08-18-2012, 08:39 AM
  4. Replies: 3
    Last Post: 06-17-2012, 11:55 AM
  5. Replies: 1
    Last Post: 07-05-2011, 11:34 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