thisform.text11.value,weight= ?thisform.text14.value,qty= ?thisform.text18.value,
> pr_rate= ?thisform.text12.value,rate=?thisform.text13.value,main=?thisform.text17.value,
> qty_m=?thisform.text21.value,qty_p=?thisform.text24.value,jute_m=?thisform.text22.value,
> jute_p=?thisform.text25.value,brqty=?thisform.text23.value where code=?thisform.text1.value
> WHERE code=?Thisform.text1.Value

>

It appears that you have your WHERE clause twice at the end of the query....that's probably what's causing the syntax error.