>>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.
Wash your glasses and look again. :-)