Access™ 2007 VBA Programmer's Reference

E.9. Record Object

The Record object represents a row from a Recordset or any object returned by a data provider. A Record object contains data from the row and allows the user to easily access that data.

E.9.1. Properties of the Record Object

The following table describes the properties associated with a Record object.

Property	DataType	Description
ActiveConnection	Variant	The Connection object used to retrieve the data for the Record object.
Mode	ConnectModeEnum	Specifies the permissions for modifying the Record object.
ParentURL	String	The Parent URL for the Record object.
RecordType	RecordTypeEnum	Specifies the type of the Record object.
Source	Variant	Specifies the source of the data contained in the Record object.
State	ObjectStateEnum	Indicates the state of the Record object.

E.9.2. Methods of the Record Object

The Record object has seven methods, defined in the following table.

Method	Description
Cancel	Cancels an asynchronous action on the Record object.
Close	Closes an open Record object.
CopyRecord	Copies the Record object to another location.
DeleteRecord	Deletes the current record.
GetChildren	Retrieves the child data associated with the Record object.
MoveRecord	Moves the Record to another location.
Open	Opens an existing Record or creates a new Record.

E.9.3. Collections of the Record Object

The Record object has two collections, just like the Recordset object. These collections are described in the following table.

Collection	Description
Fields	Contains all the Field objects for the data contained ...