An ADO Record object represents a set of data, which may be from a recordset or a non-database source. When working with Access data, the Record object is a single row from a recordset, or a one-row recordset. There are many specialized uses of Record objects based on non-Access data (in particular, for working with hierarchical data and displaying it in TreeView controls), but when working with Access data in VBA code there is no reason to use the Record object, because you can reference fields as needed on the current record in a recordset without creating a Record object.

0 0

Post a comment