Don't Use AND
Query = "INSERT INTO PROD_DB_Complete_Board (ID, [Board Size], Laminate, [Stock Level]) Values('" & TextBox4.Text & "','" & TextBox2.Text & "','" & TextBox3.Text & "','" & TextBox1.Text & "')"
Jx_Man
Nearly a Senior Poster
3,329 posts since Nov 2007
Reputation Points: 1,372
Solved Threads: 444
You wrong when put commas n single quotes. did u see my post?
Jx_Man
Nearly a Senior Poster
3,329 posts since Nov 2007
Reputation Points: 1,372
Solved Threads: 444
Use
Query = "INSERT INTO PROD_DB_Complete_Board _
(ID, [Board Size], Laminate, [Stock Level]) _
Values('" & TextBox4.Text & "','" _
& "'" & TextBox2.Text & "','" _
& "'" & TextBox3.Text & "','" _
& "'" & TextBox1.Text & "')"
It's easier to see the problem when the fields line up. I don't knkow if you have the option, but I strongly suggest you modify the database so the field names do not contain spaces. You should remove them or replace them with underscores.
Reverend Jim
Posting Shark
1,167 posts since Aug 2010
Reputation Points: 253
Solved Threads: 159