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

yes i have changed my glasses and now everything is clear.
problem solved.
thanks