Solved

Creating a New Recording a DAO Database from a form

Posted on 2014-01-28
2
353 Views
Last Modified: 2014-01-28
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?".
0
Comment
Question by:SowleMan
2 Comments
 
LVL 47

Accepted Solution

by:
Dale Fye (Access MVP) earned 100 total points
Comment Utility
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.
0
 

Author Closing Comment

by:SowleMan
Comment Utility
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.
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Suggested Solutions

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
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…

763 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

10 Experts available now in Live!

Get 1:1 Help Now