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 (=Sum([fieldname]).
The form was working fine and then without any apparent reason the text boxes appeared with an “#Error” instead of a value. The data in the query hasn't changed and if I create a new text box on the form and re-enter the same expression the new text box displays the 'correct' value (so if I ‘re-create’ all of the calculated fields I’ll have a fully working form again, but i don't want this to keep 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).
On the form I have 12 unbound text boxes that Sum data from other fields (=Sum([fieldname]).
The form was working fine and then without any apparent reason the text boxes appeared with an “#Error” instead of a value. The data in the query hasn't changed and if I create a new text box on the form and re-enter the same expression the new text box displays the 'correct' value (so if I ‘re-create’ all of the calculated fields I’ll have a fully working form again, but i don't want this to keep 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).
