Counting records on a form after filter

  • Thread starter Thread starter NeoFax
  • Start date Start date
N

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.
 
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.
Click to expand...

This works for filtered and non-filtered form records.

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