Update Multiple Tables with Form Fields (1 Viewer)

After creating all the DIM statements and setting the statement to the correct field, I type:

DoCmd.RunSQL ("INSERT INTO tableA (Field1,Field2) VALUES (""" & iField1 & """),(""" & iField1 & """)")
DoCmd.RunSQL ("INSERT INTO tableB (Field3,Field4) VALUES (""" & iField3 & """),(""" & iField4 & """)")
DoCmd.RunSQL ("INSERT INTO tableC (Field5,Field6) VALUES (""" & iField5 & """),(""" & iField6 & """)")

But when I click the submit button, I get the following:

Run-time error '3346'

Number of query values and destination fields are not the same.

Am I missing a statement between the DoCmd.RunSQL statements?

Hi. A good idea is to store the SQL statement into a String variable and examine its contents to make sure you are getting what you're expecting.

DoCmd.RunSQL "INSERT INTO tableA (Field1,Field2) SELECT " & iField1 & "," & iField1
DoCmd.RunSQL "INSERT INTO tableB (Field3,Field4) SELECT " & iField3 & "," & iField4
DoCmd.RunSQL "INSERT INTO tableC (Field5,Field6) SELECT " & iField5 & "," & iField6

arnelgp THANK YOU SO MUCH.