Hi everyone, i am encountering syntax error in my insert statement. How do i solve it?
Code:
Private Sub cmdAdd_Click()
'add data to table
CurrentDb.Execute "INSERT INTO InvestmentRecord(ID,[FSI/NonFSI],CompanyStock,Country,Branch,Currency,NumberOfShares,ActualCost,ImpairmentAllowance,GrossFairValueAdjustmentToEquity)" & _
" VALUES (" & Me.txtID & ",'" & Me.txtFSInonFSI & "','" & Me.txtSecurities & "','" & Me.txtCountry & "','" & Me.txtBranch & "','" & Me.txtCurrency & "','" & _
Me.txtNumberOfShare & "," & Me.txtOriginalCost & "," & Me.txtImpairmentAllowance & "," & Me.txtGrossfair & ")"