ADO: ActiveX Data Objects

Name

Record.Source Property — (Versions 2.5, 2.6)

Synopsis

Set record.Source = object
                  

The Source property indicates from which object the Record object is created.

Datatype

Variant

Description

The Source property is read-only when the Record object is open, but read- and write-enabled while it is closed.

The Source property can be set to a Recordset or Command object. If the Source property is set to a Recordset object, the Record object will be opened based upon the current record of the Recordset object. If the Source property is set to a Command object, the Command object must return a single row.

If the ActiveConnection property is also set, then the Source property must be set to an object that is within the connection’s scope.

The Source property returns the Source argument of the Record.Open method.

See Also

Record.ActiveConnection Property, Record.Open Method