Results 1 to 3 of 3
  1. #1
    Higherhope12 is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Apr 2017
    Posts
    1

    How to make a form default to "add new" record


    I need my form to open with a "new record" and for it only to show "1 of 1" records and not all of the other records in the table. (I do not want people to be able to scroll back over the data and accidentally type over previously entered data). I set "Data Entry" to "Yes" on the "Data" tab. For some reason, this is not working correctly on the form. The form is still showing record 1 of XXX and it is auto-populating the field with data. I need it open the form as a "new entry" with nothing populated into the fields. I also tried to add macros...1st macro was OpenForm and then second macro was GoToRecord and record = next that did not work either. I have the database up and going, but need the forma to be user friendly and dummy proof so that patient records dont get entered over b/c multiple ppl will be using it. Any ideas?

  2. #2
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    Perhaps you have some VBA code interference, or other settings causing issues.

    I would recommend creating a brand new form, then setting the "Data Entry" property to "Yes".

  3. #3
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,932
    in your docmd.openform command to open the form, use acFormAdd in the datamode parameter - it's around the 4th or 5th parameter

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

Similar Threads

  1. Replies: 1
    Last Post: 09-07-2015, 08:00 AM
  2. Replies: 1
    Last Post: 10-26-2012, 12:52 PM
  3. Replies: 6
    Last Post: 08-11-2011, 10:41 AM
  4. Replies: 16
    Last Post: 07-22-2011, 09:23 AM
  5. Replies: 1
    Last Post: 10-21-2010, 12:02 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