Error# in text box on form

[JoeA2006]

Sometimes users get an Error# appearing in one of the calulated fields on a
form. When he reboots and opens the form the data shows up correctly. I am
assuming a record may be locked from the form's last query. Assuming this is
the case What code should be used to make sure this does not happen?Could the
network be the problem?

 

[Duane Hookom]

I would try just close and reopen the form rather than "reboots" to see if
the issue resolves. If this fixes the issue then I expect a bound value in a
text box or other control that is referenced in the calculation is not being
saved.