RecordSource Property (ADO Data Control)

       

Returns or sets the statement or query that returns a recordset.

Syntax

object.RecordSource [= value ]

The RecordSource property syntax has these parts:

Part Description
object An object expression that evaluates to an object in the Applies To list.
value A string expression specifying a record source, as described in Settings.

Settings

The settings for value are:

Setting Description
A table name The name of a database table.
An SQL query A valid SQL string using syntax appropriate for the data source.