Another SQL query error

[scottie_uk]

I get an error message asking for a semi-colon at the end of statment, but it's there. What is wrong.

This is an access database being accesses in vb.net
using this query:

Dim sqlquery2 As String = "INSERT INTO productFile( productID, Name, CostPrice, SalePrice, Type, ProductDisc, SupplierID, ServingsPerUnit) VALUES ( " & prodno & ", '" & prodName & "', " & costPrice & ", " & salePrice & ", '" & type & "', '" & prodDesc & "', " & supplier & ", " & prodServ & " ) WHERE productID = " & prodno & ";"