[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1024
  • Last Modified:

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!  

  • 2
1 Solution
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
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.
sarah_siuAuthor Commented:
Worked perfectly for me...thanks!
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Thanks fore the grade.  Good luck with your project.  -Jim

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now