Visual Basic For Applications: Get a count of the number of (filltered) records in a recordset

Platform:Visual Basic For Applications
Task:Get a count of the number of (filltered) records in a recordset
Discussion:
The RecordSet.RecordCount property doesn't work on filtered records. Here's a better way:
Example:
Dim RecordCount As Integer
RecordCount = DCount("CaribouID", "CaribouLocations", Filter) 'CaribouID is a field in the CaribouLocations table, Filter is a string.
Back to Index