WHICH LINE gives this error?

>thank you,
>
>i try the second solution same error
>
>thanks
>have a nice time
>
>
>>Save yourself a lot of time and trouble, and try my second solution.
>>
>>>hi,
>>>thank you for reply,
>>>i try , i see another error message
>>>
>>>Function argument value, type, or count is invalid
>>>
>>>

>>>If Not Used('trans1')
>>>    USE trans1.dbf Alias trans1 Again In 0 Shared
>>>Endif
>>>
>>>SELECT trans1
>>>USE trans1
>>>lnValutosearch=val(thisform.text4.value)&&Function argument value, type, or count is invalid
>>>
>>>lnValutosearch=thisform.text4.value &&Operator/operand type mismatch
>>>
>>>COUNT FOR trans1.fexerno=lnValutosearch TO thisform.text2.value
>>>WITH thisform.combo1
>>>thisform.text4.value=.list(.listindex,2)
>>>thisform.text5.value=.list(.listindex,1)
>>>ENDWITH
>>>

>>>
>>>>First of all, I once again remind you to NEVER use an object in any FOR condition, use a memory variable instead, it's soooo much faster!
>>>>
>>>>In this case the error message clearly says that one of your fields or textboxes is text and not numeric, or vice versa, so we can only guess here.
>>>>

>>>>lnValutosearch=val(thisform.text4.value)
>>>>COUNT FOR trans1.fexerno=lnValutosearch TO thisform.text2.value

>>>>Or, if you use SQL which makes it easier if you later must upgrade your application to SQL server:

>>>>lnValutosearch=val(thisform.text4.value)
>>>>Select fexerno from trans1 where fexerno=lnValutosearch into cursor curdummy
>>>>thisform.text2.value=_tally

>>>>
>>>>
>>>>>hi all,
>>>>>
>>>>>i use this code it work one time, if i try again i see error message Operator/operand type mismatch
>>>>>
>>>>>

>>>>>COUNT FOR trans1.fexerno=thisform.text4.value TO thisform.text2.value
>>>>><\pre>
>>>>>thanks

Gone phishing

How to create sample data