Sorry about this question. I am very new to using Access 97 with VB, anyways here is the question.
I have an Access 97 database. it has one table in called books. in the table there is 4 fields with only about 5 rows of data. Here is an example. the first field in this simple database is called book names, under that i have 5 book titles. I want to be able to read the very first book title in that field. ( i guess this would be called a record set, im not sure) I just want to see the code to read the first field and just that one row.

Thanks for any info on this