The following sections introduce Recordset object methods and properties that you can use in your programs, featuring examples in which recordset data is accessed with the Fields list (see the section entitled “The Fields List” later in this chapter). Several syntax variants are available to access the data.
For example, if you use the command
rst.Open "SELECT FilmNr, Filmtitle FROM tblFilms", _ CurrentProject.Connection, adOpenStatic, adLockOptimistic
to open the recordset, you can use rst.Fields("Filmtitle").Value to access the current record’s Filmtitle field. Alternatively, you can use the shorter variant rst.Fields("Filmtitle") because Value is the default property. You can also use rst("Filmtitle") or an even ...