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