Have been all over for an answer to this, striking out all over!
I have an Access 2010 db with a table, the table has 3 fields: Field1, Field2, Field3.
I have an unbound form used for data entry with 3 unbound text boxes, Field1, Field2, Field3.
I want to use the values in the text boxes to append a new record to the existing table. Tried building the sql string like so:
sSQL = "INSERT INTO tblOne ( Field1, field2, field3 )" & vbLf
sSQL = sSQL & " VALUES ('" & Me.Field1.Value & "', '" & Me.Field2.Value & ", " & Me.Field3.Value & ");" & vbLf
'sSQL = sSQL & " FROM forms!tblOne"
I'm not very good at sql, but intuitively the 3d line of the sSql construct (the "FROM" line referring to a form name) looks wrong. But even going without it, I get a syntax error 3075.
Thanks in advance for helping lead me back to the beaten path on this one.