Access 2007 forms - unable to additional records after exiting the form

Posted on 2012-09-19
Last Modified: 2012-09-19
I have a form in Access 2007.  I'm able to add a new record through the form.  I can then go back with the record selector(at the bottom) and see the record.  I can also run the query used for the form and see the information in the query.
When I close the form, then open it again, the data is no long showing.  
Is there a setting I'm missing?
Question by:javierpdx
    LVL 61

    Accepted Solution

    Change the Data Entry property to NO.

    If it is set to Yes, your form is set up for entering new records exclusively - not editing existing ones.  Setting it to NO allows editing of both new and existing records.

    Author Closing Comment

    Thanks.  That did it.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Join & Write a Comment

    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

    728 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

    21 Experts available now in Live!

    Get 1:1 Help Now