data transfer when filling a form

[xxyy]

Dear All!

(I sent this problem into the FORM-forum as well but maybe it belongs to here)

I'd like to ask you to help me in the following. The issue is basic I think, but not for me...

I'd like to transfer the data entered in the fields of a form into the fields of a table (that uses the same values). This table is connected with one to one relation to the table which the form bases on.

(An automatic data-transfer would be desirable. If it is difficult a button will do as well.)

Please write if you have got any good idea or solution.

Thanks in advance.

BR
xxyy

 

[DB7]

Private Sub Form_AfterUpdate()

CurrentProject.Connection.Execute _
"INSERT INTO tblOne(txtName,txtCity...)" & _
"VALUES('" & Me.txtName & "','" & Me.txtcity....& ")",,129