Question Sum value of table and then requery to build a running sum

[shabbaranks]

Hi,

Im trying to sum a value within subform\table before I even start I get ####Error as I have put in the control source the rule to create the sum

=Sum([TempTable].[hours])

I then have a function when another value is added it requires the text box which holds the sum value.

Can anyone assist please?

Thanks

 

[CJ_London]

what is ####error? you usually get #### because the control is not wide enough