RecordSource Property

Object List Next Object

Defined By: Recordset

Indicates the RecordSet's underlying database source, which can be an SQL query statement or a table name. This property is only valid when the DatabaseType property is set to ODBC.

Details:

Use the RecordSource property to determine which records are included in the RecordSet. To load data after a change has been made to the RecordSource property value, execute the Refresh method.

The new object created by changing the DataControl's RecordSet.RecordSource property value is identified by the RecordSet when you Refresh. This operation may render the DataField settings of bound controls invalid. Because of this, you should ensure that the DataField property value is valid for each bound control on your form.

Data Type: String