Missing Operator error

[jlg5454]

Hi,

I keep getting a missing operator error from this query off my add button when I try to populate form data into a table. The error seems to around Vendor

Code:

DoCmd.RunSQL "INSERT INTO tblInbound_Sales " & _
"VALUES (" & _
"'" & txtCallFileNum.Value & "'," & _
"#" & txtDte.Value & "#," & _
txtScore.Value & "," & "'" & Me![Vendor] & "'" & _
txtApgret.Value & "," & _
txtPolite.Value & "," & _
txtUseNAP.Value & "," & _
txtEnsval.Value & "," & _
txtBrandedCall.Value & "," & _
txtKYC.Value & "," & _
txtKnowledge.Value & "," & _
txtCorrectinf.Value & "," & _
txtPermprob.Value & "," & _
txtNeedofpref.Value & "," & _
txtStroprodrec.Value & "," & _
txtcustcom.Value & "," & _
txtCrossSellUpSell.Value & "," & _
txtcallback.Value & "," & _
txtpropuse.Value & "," & _
txtvalidate.Value & "," & _
txtlistencall.Value & "," & _
txtanyelse.Value & "," & _
txtconcealed.Value & "," & _
txtthanked.Value & "," & txtComments & ")"

Any help would be appreciated.

Thanks

 

[PHV]

Check the output written in the debug window when you replace DoCmd.RunSQL with Debug.Print

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886