lnValutosearch=val(thisform.text4.value) COUNT FOR trans1.fexerno=lnValutosearch TO thisform.text2.valueOr, 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,
>COUNT FOR trans1.fexerno=thisform.text4.value TO thisform.text2.value
><\pre>
>thanks