ADODB is a library (dll). A Recordset is a class defined in that library, and a Field is also a class in that library. There is no Field property or other such member with that name in the Recordset class. There is a Fields collection whose members are Field objects. Finally, the Field object has a Value property.
Thus, the reference might be:
ADODB.Recordset.Fields(1).Value
The Library/Dll name is optional as long as no other library referenced in the project has a Recordset Class. If there is, and thus:
Recordset.Fields(1).Value
is ambiguous, then the first library containing the object reference is the one that is used. This is why the Project References dialog has up and down buttons labeled 'Priority' - so the order can be changed if need be. It's probably better (IMO) to spell out the full reference in this case, though, as it is clearer which library is being used.
Jeff Mason
Custom Apps, Inc.
www.custom-apps.com