recordset clone recordcount ?

[mscertified]

I'm trying to display the current rowcount in my form caption.
I'm using the recordset clone recordcount to do this.
I get the correct count after I filter the records but when my form first
opens, the count is always just 1. In what event can I get this count after
my form opens. I can do it in 'on current' but then it updates after every
record navigation and I only need it to update when I first open the form and
then after a filter is applied.

Thanks.

 

[Klatuu]

The recordcount for any recordset will return 1 if there are any records in
the recordset until the recordset is fully populated. To get the actual
count, you will have to move to the last record and back to the first.