Calculated Control value appears but dissapears

[Kozbot]

Hello

I have a calculated control on a form that is summing other controls and then a subtotal on a subform. This is access 2007

The calculated control does not display the value until I enter a value other then the default in all of the source controls. If I hit the "refresh" button, the value appears in the calculated control for a moment, then disappears.

I have set the default of the source controls to be 0, so none are null.

What could be causing this? the calc control value does not stay until I put a value in the subform and its subtotal thus has a value

 

[pr2-eugin]

Which event fires this calculation?

 

[Kozbot]

Which event fires this calculation?

There is none. it just has =[QuantityOrder]+[QuantityStock]+[QuantityPartial]+[QuantityDowngrade]+[frmOtherMaterialProduced].[Form]![Othermatsubtotal] as the control

 

[pr2-eugin]

So what has? Is it the Control Source/Default value? I am guessing Default value.. Change it to control source.. Also you need to recalcuate the control after updating the values in the other controls.

 

[Kozbot]

So what has? Is it the Control Source/Default value? I am guessing Default value.. Change it to control source.. Also you need to recalcuate the control after updating the values in the other controls.

No I defined it as the control source.

I defined the default value of the source controls as a numerical zero.

Do I have to specify the control recalculate on a certain event.

the value only remains displayed in the calculated control after I enter a record in the subform source control.

 

[pr2-eugin]

Yes, in the After Update of the other controls..