Our textboxes which have functions such as Count, Dcount, CurrentUser stop working from time to time. When they don’t’ work, none of them work; they don't work on any of the forms in the system. Clicking on the textbox or pressing F9 will cause the data to be shown for the current record. This issue was discussed on the Stackoverflow forum about a year ago and was left with the suggested workaround:
Private Sub Form_Activate()
Me.SetFocus
SendKeys "{F9}"
End Sub
This seems to work, but somehow this just doesn't look robust to me. Is this workaround ok? Can anyone suggest a better fix? Anyone know why this is happening?