thank you very much.

>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