| 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. |