Check if the textboxes are holding the same data type as the field of the table.
Luis
>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
I never forget a face, but in your case I will make an exception :-)