SourceField, SourceTable Properties

See AlsovbproSourceFieldNameSee                 ExamplevbproSourceFieldNameEx>Low

Applies To

Field objectKU5EEE.


Indicates the name of the field or table that is the original source of the data in the Field object.  Not available at design time; read-only at run time.


recordset | tabledef }.field.SourceField

recordset | tabledef }.field.SourceTable


You can use these properties to discover the original source of your data.  The Recordset property of a data control is a Dynaset object that can be the result of a query on several tables.  Depending on how the query is constructed, any field may or may not have the same name as in the original table.

Data Type