No problems.
In that case, I suggest you do one of the following.
Method 2 is in my view better
1. Move your recordset.clone code to Form load but ignore the caption line
This should force the record counter to display as you want but it will cause a short delay.
Do bear in mind this will get slower over time as additional records are added
2. Use a main form with datasheet subform
In the main form footer, use an unbound textbox and call it e.g. TotalRecords.
In the form load event, enter
Code:
Me.TotalRecords =DCount("*","YourQueryName")
That may allow your form to load instantly with the count appearing after a very short delay.
If it 'hangs', there s a simple solution involving a form timer event...but try that first.