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