Syntax error in INSERT INTO ERROR 3134

[Purdue15]

I dont know what is wrong at all!

Private Sub cmdNewAdd_Click()
'add data to table
Dim strSQL As String

strSQL = "INSERT INTO CTracking(SKU, Warehouse)""Values('" & Me.ccrtSKU & "','" & Me.ccrtWarehouse & "')"

CurrentDb.Execute strSQL
End Sub

 

[pbaldy]

This should help:

http://www.baldyweb.com/ImmediateWindow.htm

For starters, the quotes before the word "Values" need to come out.

 

[Purdue15]

Thanks I am an idiot it was just the "" I had before values

 

[pbaldy]

No problem. I thought that was all, but wanted to give you the debugging method anyway. It's a common way of figuring these things out.