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
