Could anyone tell me what I'm doing wrong? I've looked it up and I can't figure it out. But, basically, there are two dates on the entry form that I want copied to other tables. There's Me.DateofOrder and Me.DateRequired. They should be copied to fields of the same name in other tables. I managed to get past errors, but nothing has shown up in the fields of those tables. This example inserts the data into the shipRECtbl. The entries in question are in red.
DoCmd.RunSQL "INSERT INTO shipRECtbl (JobIDfk, Customername, SalesOrderNumber, CustomerPO, DateofOrder, DateRequired) VALUES ('" & Me.JOB_ID & "','" & Me.CustomerName & "','" & Me.SalesOrderNumber & "','" & Me.CustomerPO & "','" & "#Me.DateofOrder#" & "','" & "#Me.DateRequired#" & "' );"
End Sub
Thanks in advance.