Hi.
I have a text box on a form with the control source set to
=[Forms].[formname].[RecordsetClone].[RecordCount]
There are 1319 records in the recordset.
The first time I open this form it gets the count wrong and displays 501. However If I change the form's view to "design" and then back to "form" it gets the recordcount right. This is the only way it will work. It's been driving me mad for days!
Does anybody have any ideas why it would do this?
Many thanks in advance.
I have a text box on a form with the control source set to
=[Forms].[formname].[RecordsetClone].[RecordCount]
There are 1319 records in the recordset.
The first time I open this form it gets the count wrong and displays 501. However If I change the form's view to "design" and then back to "form" it gets the recordcount right. This is the only way it will work. It's been driving me mad for days!
Does anybody have any ideas why it would do this?
Many thanks in advance.