>>>>The type mismatch, in this case, stems from the fact that recno() is numeric, and cTextBox.Value is character. Use val(ThisForm.cTextBox.Value) to convert it to numeric.
>
>>>>Hilmar.
>
>>>I had realized that and went the other way using STR(RECNO()). Didn't work very well. I hadn't found VAL() yet. The pointers are much appreciated.
>
>>>Matthew
>
>>The problem here is that str(recno()) returns (for record #15): "________15" (replace the underscore with spaces). This will not exactly match a user input of "15" or of "15__________".
>
>>Hilmar.
>
>Out of curiousity, ALLT(STR(RECNO()))?
>
>Matthew
Yes, that might work. However, you may have problems with too many records selected (see: SET EXACT ON).
transform(recno()) is supposed to work too, but it gives wrong results for some numbers.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)