Returns a Recordset object that represents the recordset resulting from a recordset definition or grouping definition. If the recordset is part of a hierarchy of chaptered recordsets, the data source control creates the entire hierarchy and returns the requested recordset from the hierarchy.
Syntax
expression.Execute(RecordsetName, ExecuteOption, FetchType)
expression An expression that returns a DataSourceControl object.
RecordsetName Required String. The name of the recordset definition or grouping definition.
ExecuteOption Optional ADO ExecuteOptionEnum. Specifies how the query is performed. The default value is adOptionUnspecified.
FetchType Optional dscFetchTypeEnum. If the specified recordset definition contains sublist child recordset definitions, setting this argument to dscFull causes all records to be fetched whenever the Execute method is called. If you do not specify this argument or you set it to dscParameterized, records in child recordsets are fetched only when the child recordset is opened for a given parent. For example, if you have a Customers parent with an Orders child and this argument is set to dscFull, all records for all customers are fetched at run time. If this argument is set to dscParameterized, recordsets for customers with Customer ID 'ANTAR' are fetched only when the Customers recordset is positioned on this Customer ID and the child Orders recordset is opened.