Writing record to table

[Jason]

I want to use the after update event to transfer data from
an unbound text box and three other fields on a form into
a new record of a table.

What's the code for this action?

Thanks in advance,

Jason

 

[Ruskin Hardie]

Try something like;

DoCmd.Setwarnings False
DoCmd.RunSQL "INSERT INTO

([Field One]," & _
"[Field Two],[Field Three],[Field Four]) VALUES (" & _
"'" & unbound_text_box.value & "','" & field_one.value & _
"','" & field_two.value & "','" & field_three.value & "');"
DoCmd.Setwarnings True