>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.

I used Where clause only once.