sending values from a form

[xxyy]

Dear All,

I have another question too.

It is possible to send data from a form (that doesn't base on any tables) to tables?

I mean that after filling the fields of a form and then clicking a button the records of relevant tables would be set automatically.

thx

 

[DB7]

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

or

"UPDATE tblName Set txtName ='" & Me.txtName & "', txtCity ='" & Me,txtcity & "'"