>>I just couldn't get the syntax right for SELECT-SQL. The methods I tried either did not select a record or returned a data type mismatch error ( using recno() = cTextboxValue). I'm used to some aspects of SQL, but just couldn't get it to work for me. Back to the books. Thanks.
>In this case, to print a single record, it might not be necessary.
>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
Opportunity is missed by most people beacuse it is dressed in overalls, and looks like work --- Thomas Edison