How To Calculate Total from values of other fields

[Welshgasman]

Wedshgasman, because that approach doesn't work.

So why not just say so and continue on that thread?



After all, all you are doing is summing four controls and ensuring they come to 100 only.

[June7]

Your expression is wrong because of the brackets - ,0 needs to be outside the brackets. But it is true that if it weren't for the division by 100, the numbers coming from text fields would concatenate instead of add. So either fix the fields or use Val() function.

[Pada]

Your expression is wrong because of the brackets - ,0 needs to be outside the brackets. But it is true that if it weren't for the division by 100, the numbers coming from text fields would concatenate instead of add. So either fix the fields or use Val() function.

Great, June7. Thank you for your advice. I will take notes.

[Pada]

So why not just say so and continue on that thread?

After all, all you are doing is summing four controls and ensuring they come to 100 only.

Sorry to bother you guys, but I would like to start fresh to clear up my mind. If I stayed in the same spot, I might be drowned myself in confusion and a foggy brain.

[Welshgasman]

Sorry to bother you guys, but I would like to start fresh to clear up my mind. If I stayed in the same spot, I might be drowned myself in confusion and a foggy brain.

Take a step back, take a deep breath and think of what you want to do.
Build it up in small steps, then put code around it if need be.

In the BeforeUpdate event of the form, I would just sum those controls with NZ() as June7 advised, and if not 100 then set it's Cancel property.