As I wrote earlier, you must make sure that all relevant values are of the same types.

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

>this line
>
>Select fexerno from trans1 where fexerno=lnValutosearch into cursor curdummy
>
>
>>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