SourceField, SourceTable Properties

           

• SourceField — returns a value that indicates the name of the field that is the original source of the data for a Field object.
  
  
• SourceTable — returns a value that indicates the name of the table that is the original source of the data for a Field object.

Return Values

The return value is a String specifying the name of the field or table that is the source of data.

Remarks

For a Field object, use of the SourceField and SourceTable properties depends on the object that contains the Fields collection that the Field object is appended to, as shown in the following table.

Object appended to	Usage
Index	Not supported
QueryDef	Read-only
Recordset	Read-only
Relation	Not supported
TableDef	Read-only

These properties indicate the original field and table names associated with a Field object. For example, you could use these properties to determine the original source of the data in a query field whose name is unrelated to the name of the field in the underlying table.

Note The SourceTable property will not return a meaningful table name if used on a Field object in the Fields collection of a table-type Recordset object.