>>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