Sum on a form

vipersmind

it can't be!
Local time
Tomorrow, 03:53
Joined
Dec 26, 2002
Messages
82
I know that this may seem like it's been answered 1000 times on this forum already but I can't figure it.............

I am trying to sum some fields on my subform but it keeps comming up with #error. I know all of the reasons why it would normally do this.
Naming controls the same.
Not looking at the right control.
Circular references.

My forms control sources are both temp tables.
Sometimes it works and gives me the correct figure but then I come back to it the next day and it won't work at all.

I have attached a cut down version.
Pls help as it is making me have a meltdown.
Cress
 

Attachments

Last edited:

Users who are viewing this thread

Back
Top Bottom