Writing record to table

  • Thread starter Thread starter Jason
  • Start date Start date
J

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
 
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
 
Back
Top