What's the difference between add and edit mode for opening a form in Access?

Posted on 2008-11-13
1 Endorsement
Last Modified: 2013-11-28
Hi there.  I've got a database with a particular form which I want to default to a new blank record when it's opened, although someone may decide to then select a record.  However, if I open the form in "add mode" from the switchboard, it doesn't then allow any selection of other records, while if I open it in "edit mode" it defaults to a particular record when opened each time.  It's confusing me as I'm not really sure why add mode isn't letting me do what I think it should be (!)  Is there a way I can get round this?
Question by:fernandoweb
    LVL 11

    Accepted Solution

    Add mode is intended to only allow new records to be created. So in Add mode the form does not display any older records.

    Edit mode allows you to view and edit existing records, and to add new ones.

    In order to achieve your goal (defaulting the form to a new record when it opens) set the "Allow Edits" to Yes and "Data Entry" to No. Then you just need a line of code in the form's OnOpen event...

    DoCmd.GoToRecord , , acNewRec
    LVL 1

    Assisted Solution

    hi fernandoweb,

    make sure that you "data entry" property in the form is set to NO.

    good luck,


    Author Closing Comment

    Many thanks

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
    My experience with Windows 10 over a one year period and suggestions for smooth operation
    The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    731 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now