ADO Record object >>Source Property

The Source property returns a variant value that is the source parameter of the Open method of the Record object.

The Source property sets or returns a variant that is the source of the entity represented by a Record object. This can be the relative or absolute URL string of the entity to be represented by the Record object, or a reference to an open Recordset object where an open Record represents the current row in the Recordset.

When the Record object is open, this property is read-only and returns the Source parameter of the Open method of the Record object. When the Record object is closed, this property is read/write.

Syntax

varSource=objrecord.Source
objrecord.Source=varSource

Example

varRecordSource = objRecord.Source