RecordSourceType Property

Applies To   See Also

Specifies how the data source that populates the Grid control is opened. Available at design time and read/write at run time.

Syntax

Grid.RecordSourceType[ = nType]

Settings

nType

The settings for the RecordSourceType property are:

Setting Description
0 Table. Automatically opens the table specified in the RecordSource property setting.
1 (Default) Alias. Treats the record source as specified.
2 Prompt. The user is prompted for the record source at run time. If a database is open, the user can choose one of the tables it contains as a record source.
3 Query (.qpr). The RecordSource property setting specifies a .qpr file.
4 SQL Statement. The SQL statement is specified in the RecordSource property.