I tried to change and it still prompt me the same error.
CurrentDb.Execute "INSERT INTO InvestmentRecord(ID,[FSI/NonFSI],CompanyStock,Country,Branch,Currency,NumberOfShares,ActualCost,ImpairmentAllowance,GrossFairValueAdjustmentToEquity)" & _
" VALUE (" & Me.txtID & ",'" &...