Run time error 3134, syntax error in INSERT INTO statement 1

[shaheer1991]

Private Sub go_Click()

CurrentDb.Execute "INSERT INTO table (User ,ProjectName ,WorkingPackage, Activity) VALUES ('" & Me.User & "','" & Me.PN & "','" & Me.WP & "','" & Me.AN & "')"

subform.Form.Requery

End Sub


says syntax error in insert statement, i seriously can't find what's wrong

 

[SkipVought]

hi,

You have a table named table???

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[shaheer1991]

dude thx, am soo stupid.. didnt notice it O my good too mee time