DCount on filtered subform

[TheShabz]

Hi all,



I'm looking to get a count of records in a filtered subform on my mainform with a specific criterion. I'm not sure how to reference the filtered subform, however.

DCount("*", "[filtered subform]", "some field = " & someControl)

I've tried Me.subform.Form.RecordSetClone, ...RecordSet, ...RecordSource

Help?

[boblarson]

How about using:

Dim rst As DAO.Recordset
Dim lngCount As Long
 
Set rst = Me.subformControlNameHere.Form.RecordsetClone
   Do Until rst.EOF
      If rst![Some Field Name Here] = Me.SomeControl Then
         lngCount = lngCount + 1
      End If
      rst.MoveNext
   Loop
 
rst.Close
Set rst = Nothing
 
Me.SomeControlHere = lngCount

[TheShabz]

Thanks. I had a feeling DCount wasn't going to suffice.