We help IT Professionals succeed at work.

Access 2007 - data entry form

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!  

Thanks!
Comment
Watch Question

SQL Server Data Dude
CERTIFIED EXPERT
Most Valuable Expert 2013
Author of the Year 2015
Commented:
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

Commented:
Worked perfectly for me...thanks!
Jim HornSQL Server Data Dude
CERTIFIED EXPERT
Most Valuable Expert 2013
Author of the Year 2015

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

Explore More ContentExplore courses, solutions, and other research materials related to this topic.