Problem Storing a value calculated by unbound text boxes

[Mikk]

I have 3 values in unbound text boxes and a 4th text box that is calculating the sum of the first three text boxes, i need the result of the calculation to be stored in the field "Total Cost" that is also on this form.

Any ideas

Cheers Mikk

 

[RuralGuy]

It is almost always a bad idea to store calculated values in a field in a table. If you must then the form's BeforeUpdate event is where you can accomplish the task smoothly. What would be the problem with calculating the value each time?

 

[Mikk]

I just thought it would be better that way, what would i need to put in the before update event? atm i have the boxes set control source like: =IIf([Name of Yes/No field]=True,15,0) and the calculating unbounded box: =[Text38]+[Text40]....etc. Thanks for the reply RG!

Hope you can help

Mikk

 

[RuralGuy]

[Total Cost] = UnboundTextBoxName

Using the names of your [Field] and UnboundTextBoxName of course.

If *any* of the other controls change then you will have a stored calculation that is not correct and no easy way to identify it!

 

[Mikk]

Decided to change my form around and do it a different way, thanks for your help RG!

 

[RuralGuy]

You're welcome. Thanks for posting back.