Recordsetclone.Recordcount stops working for no apparent reason

[Julia Boswell]

All,

I've got a continuous bound form that has a counter on it (in the form of a
disabled text box) showing the number of new records a user has entered. The
counter is populated by the form's after update event as follows:

Me.txtCounter = Me.RecordsetClone.RecordCount

This has worked for a couple of years with no problems until over the last
week it's suddenly stopped working randomly (but not all the time). The user
will have entered multiple records and the counter will suddenly freeze -
the user can continue to enter data but the counter does not increment.

The form has a confirm & cancel button, neither of which respond when the
counter has frozen, although the user can continue to enter records.

The user believes that the counter stops working when a Lotus Notes email
notification shows on his screen.

I have no idea where to look for a possible cause of this. Have tried
several Google searches and can't find anything similar.

Has anyone any ideas?

Thanks

Julia

 

[Allen Browne]

What happens if, instead of programmatically assigning the value, you get
Access to keep it up to date by setting the Control Source of the text box
to:
=[Form].[RecordsetClone].[RecordCount]

Note that things like ServerFilter of Filter might affect this as well.