Counting records on a form after filter

[NeoFax]

I have a form that contatins 5 comboboxes that allow data mining of
the underlying query. This all works well using code. However, now I
need to be able to count the filtered records. I have tried using a
dcount, but this only counts all of the records and not only the
filtered ones. I was thinking of using recordset.clone to solve this
problem.

 

[fredg]

I have a form that contatins 5 comboboxes that allow data mining of
the underlying query. This all works well using code. However, now I
need to be able to count the filtered records. I have tried using a
dcount, but this only counts all of the records and not only the
filtered ones. I was thinking of using recordset.clone to solve this
problem.

This works for filtered and non-filtered form records.

="Record # " & [CurrentRecord] & " of " &
RecordsetClone].[RecordCount]