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

Creating a New Recording a DAO Database from a form

I want to add a new record to a DAO recordset by entering info in a form. The form is based on the DAO recordset. Should I create the record first (using .AddNew and .Update), then open the form? Or open the form, allow the operator to enter the data, then use .AddNew and .Update?  Kind of like the old question "Which comes first: the chicken or the egg?".
1 Solution
Dale FyeCommented:
Why are you not simply using a bound form?

When you bind a form to your table, the updates/additions you create are automatically saved.
SowleManRetiredAuthor Commented:
I don't use ACCESS/VBA a lot. I failed to think of a form's ability to add a new record and save it. A "new guy" mistake. Thanks. I used your suggestion and (obviously), it was successful.  Thanks.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

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