DAO Object
 
Returns a value that indicates the name of the field that is the original source of the data for a Field object. Read-only String.
 

Syntax

expression .SourceField
expression A variable that represents a Field object.
 

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.