insert into query not populating the desired table

[moises]

I have coded my save button with the vba editor in my access.



Currentdb.execute "insert into tbldata (field1, field2)values(" & me.value1 "," & me.value2 "');"

The code has no error but it's not populating the table.

Could anyone help me with the code?

[pbaldy]

I'd use a variable so I could check the finished SQL:

BaldyWeb-Immediate window

Also, you can add a comma and dbFailOnError after your SQL or variable and you'll probably get your error.

[John_G]

There are syntax errors in the SQL (extra single-quote and missing &):

Currentdb.execute "insert into tbldata (field1, field2)values(" & me.value1 &"," & me.value2 "');"

Please post the real SQL you are using; if what you show is what you are using, then is the table REALLY named tbldata, and are the table fields REALLY named field1 and field2?

[pbaldy]

There are syntax errors in the SQL (extra single-quote and missing &):

Currentdb.execute "insert into tbldata (field1, field2)values(" & me.value1 &"," & me.value2 "');"

I'll get out of John's way, as I was going to try and teach you how to fish. That said, there's still a missing &.

[moises]

Mr. John_G attached is the database. I have an syntax error 3075.

[moises]

Thanks guys