to bind a form to a table (or a query), open the form in design view and, in
the Properties box, click on the RecordSource property. enter the name of
the table or query you want to bind the form to, and now it's bound.

to bind controls on a form to fields in the form's RecordSource, open the
form in design view and click on a control. in the Properties box, click on
the ControlSource property. enter the name of the field, from the form's
RecordSource, that you want to bind the control to, and now it's bound.
repeat for each control that you want to bind to a field in the
RecordSource.

if you bind your form/controls to a table(or query)/fields, then you are
essentially entering data directly into the table, via the form interface,
with no need for an Append query to write the data to the table.

hth

You can use a button on the form, after all the selections are made and the
user click on the button you can run this code to save the record in the
table, use the OnClick event of the button to run the SQL