Sum values of calculated control

[TTThio]

Hello,

I have a unbound txtbox1 which looks up value in the underlying query. Then I have another unbound txtbox2 to sum up the values in txtbox1 using this formula:
=sum([Forms]![Form1]![txtbox1])
But it keeps show #error#.

What happens?

Thanks ahead!

 

[JoeMiller]

You normally get #error when there is a lack of records matching the criteria specified by the equation. Check that there are records in the query for what you are trying to sum.
Joe Miller
joe.miller@flotech.net

 

[TTThio]

The dlookup function is the control source of the textbox1.
So, the values are not stored to any query or table.
I try to sum up the values in other textbox (also unbound)because I need to do a cummulative calculation, where total lookup values + current record value.

 

[JoeMiller]

In the after update of the control that you are entering in the data that is being added put in a line that refreshes your Total box. Something like this:

[tt]
MyTotalBox.Requery
[/tt]

Hope that helps! Joe Miller
joe.miller@flotech.net