add new record from form to DB table

[eugzl]

Hi All.
I created my first form which include cascaded combo boxes and some text boxes. Now I would like to modify it to give user ability to save selected values from combo boxes and entered date to text boxes from form to DB table. How create VBA code to perform save event? I will appreciate if someone will explain and show by sample how it to do.



Thanks.

[June7]

Don't need VBA. Bind form to table and controls to fields. Data input/selected will pass directly to table. This is basic Access functionality and a major benefit of using Access as GUI.

[eugzl]

Hi June7.
I would like create the form with such options:
1. The form should have options to check validate data and validate of the required fields
2. if all validations are OK, enable the SAVE button to give user ability to save record
3. when save button is clicked it will initialize all form's fields to give user ability to create another new record

Thanks

[June7]

Validation can be done with bound form and controls. That's what the BeforeUpdate event is for. Also have ValidationRule property of controls.

A record is committed to table when: 1) close table/query/form; or 2) move to another record; or 3) run code to save.

So all button needs to do is move to new record row and the initial record is committed and form is ready for user input to a new record.

Can use unbound form and controls for data entry if you want - I never have.

This is a common topic so many examples. At least 2 methods for saving data from unbound form.

[mike60smart]

Hi
Upload a zipped copy of the database so we can take a look at your structure.