#error

[a]

Access2007

I'm using form footer to make calculation to field in data sheet view form .
why to take the expression in main form (master form)

In the text box I put this expression (form footer)

= sum ([totalmoney])

This error appear to me in the text box #error

 

[Allen Browne]

What is totalmoney?

If it is a field in the table/query that supplies records to the form, you
can use an expression like that. But you cannot do that if totalmoney is a
text box that has some expression in it. For example, if totalmoney is a
text box with Control Source of:
=[Quantity] * [PriceEach]
then you need to repeat that expression in the text box in your form footer,
i.e.:
=Sum([Quantity] * [PriceEach])

Another problem arises if there are no records at all in the form - not even
the new record. In that case, the Detail section goes completely blank, and
any attempt to sum the non-existent text boxes will error. More on this
issue:
Why does my form go completely blank?
at:
http://allenbrowne.com/casu-20.html