Recordset Property

See AlsovbproRecordsetSee                 ExamplevbproRecordsetEx>Low

Applies To

Data control2E1FEX3.

Description

A DynasetUDR386 defined by a data control's Connect, DatabaseName, and RecordSource properties.  Not available at design time.

Syntax

[formname.]datactrl.Recordset.propertyname [ = propertyvalue ]

[formname.]datactrl.Recordset.methodname [ argumentlist ]

Remarks

The Recordset property is a reference to the underlying database object of a data control.  It has all the same properties and methods of its underlying Dynaset.  Setting its properties is the same as setting the properties of the underlying Dynaset.  Likewise, you can use any methods of a Dynaset as well.

The following example shows how you can combine the RecordCount property of a Dynaset with the Recordset property to display the number of records in a data control's recordset:

Data1.Recordset.MoveLast
MsgBox "Records: " & Data1.Recordset.RecordCount