Sql Statement

[jamesnkk]

Hi, When I try to issue the SQL Insert statement that combine with variable "mycomp" , it display error message, how do or what the proper method to combine the field name together with variable ?

Please Advise


dim mycomp as string
mycomp="ABC"

sqlsR = "Insert into tblvndProd(Prod uctID,part_no,V endPartNo,desp, unit,firstrecor d,vendor) values(Forms![frmMstock]![productID],Forms![frmMstock]![partnos],Forms![frmMstock]![partnos],Forms![frmMstock]![desp], Forms![frmMstock]![unit],'FIRST'," & mycomp & ");"

Sorry, I manage to Solve it.

[jamesnkk]

Sorry, I manage to Solve this, thanks anyway