Results 1 to 4 of 4
  1. #1
    Martyr is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2013
    Location
    Raleigh, NC
    Posts
    2

    Post When I open my new form it has my first record already in it. How do I get a blank?

    I used the AutoForm tool to create a form but when it opens it already has the first record data in it and I can't seem to find a way to get it to show blank spaces to allow entering new data. Will appreciate help!

    Marty

  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,632
    Have to move to new record. Can use the intrinsic navigation bar at bottom of form (if it is enabled). Enable/disable by setting the form's NavigationBar property.

    Alternatives:

    1. command buttons and code.

    2. allow only new record entry by setting form DataEntry property to Yes
    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.

  3. #3
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    Or, to open to New Record but still see existing Records:
    Code:
    Private Sub Form_Load()
      DoCmd.GoToRecord , , acNewRec
    End Sub

    Linq ;0)>

  4. #4
    Martyr is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2013
    Location
    Raleigh, NC
    Posts
    2
    Thanks June 7 you solved my problem !!!

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

Similar Threads

  1. Form keeps showing up blank on open
    By rthakral in forum Forms
    Replies: 3
    Last Post: 09-24-2013, 01:35 PM
  2. Replies: 1
    Last Post: 05-03-2012, 02:25 PM
  3. How to open a blank form?
    By WhatnThe in forum Access
    Replies: 15
    Last Post: 08-05-2011, 02:41 PM
  4. I want my form to open blank
    By uneek78 in forum Forms
    Replies: 10
    Last Post: 01-12-2011, 01:01 PM
  5. Replies: 4
    Last Post: 10-20-2010, 10:38 AM

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