See Also Example
A Dynaset Not available at design time. defined by a data control's Connect, DatabaseName, and RecordSource properties.
[formname.]datactrl.Recordset.propertyname [ = propertyvalue ]
[formname.]datactrl.Recordset.methodname [ argumentlist ]
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:
MsgBox "Records: " & Data1.Recordset.RecordCount