How do i Troubleshoot a form/Text box Error?

[mrl]

I have a datasheet Form that is based on a query.

On the form I have 12 unbound text boxes that Sum data from other fields eg; =Sum([fieldname]).
The form was working fine and then for no apparent reason these text boxes appeared
with an “#Error” instead of a value.

The data in the query hasn't changed and if I create a new form based on the same query and create a text box with
the same expression it displays the 'correct' values, while the original Form/text boxes with the same expressions display an
error! (so if I ‘re-create’ all of the text boxes I’ll have a fully working form again, but i want to stop this from re-occurring).

Is there any way I can find out what is causing the “#Error” in the text boxes???


(Using Access 2007 on Win XP).

[Missinglinq]

The answer probably hasn't changed since your post of yesterday:

http://www.utteraccess.com/forum/Tro...-t2006023.html

And here are some articles on Corruption by some leading experts:

Allen Browne on Preventing Corruption
http://allenbrowne.com/ser-25.html

Allen Brown on Recovering from Corruption
http://allenbrowne.com/ser-47.html

More Allen Brown: The Recovery Sequence
http://allenbrowne.com/recover.html

Tony Toews on Corruption.
http://www.granite.ab.ca/access/corruptmdbs.htm

Symptoms of corruption
http://www.granite.ab.ca/access/corruption/symptoms.htm


And since I've cited him three times, here, here's the Home Page to Allen Browne's site, probably the most comprehensive in the world, for all matters Access, and the first place I look when I'm having problems:

http://allenbrowne.com/tips.html

Linq ;0)>

[orange]

In addition to Linq's list, here is an article on debugging by Chip Pearson.
It mentions Excel, but it is equally applicable to Access

http://www.cpearson.com/excel/DebuggingVBA.aspx