Access 2007 - data entry form

Posted on 2012-08-14
Last Modified: 2012-08-14
Hi Everyone,

I have created a form on Access 2007.  Currently, the form pulls the first record in the database and automatically populates the related fields.  I would like to make this form a submit form instead (no records coming back).  I know there's a data entry field where I can set the form to entry form instead but I can't seem to locate it anywhere.

Can someone please help me make my form input only!  

Question by:sarah_siu
    LVL 65

    Accepted Solution

    In Form Design, do a ctrl-P to get to the Properties dialog, then make sure the selection type shows Form.

    Then click the Data tab, and Datra Entry is about two-thirds down.

    Author Closing Comment

    Worked perfectly for me...thanks!
    LVL 65

    Expert Comment

    by:Jim Horn
    Thanks fore the grade.  Good luck with your project.  -Jim

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
    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…
    What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
    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…

    761 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

    11 Experts available now in Live!

    Get 1:1 Help Now