Access 2003 VBA Programmer's Reference

D.9. Record Object

The Record object represents a row from a Recordset or any object returned by a data provider.

D.9.1. Properties of the Record Object

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

Property	Data Type	Description
ActiveConnection	Variant	The Connection object used to retrieve the data for the Record object
Fields	Collection of Field objects	Pointer to the collection of Field objects that contain data
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

D.9.2. Methods of the Record object

The Record object has seven methods, listed 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 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

D.9.3. Collections of the Record Object

Collection	Description
Properties	Contains all the property objects for the current command object