Field not calculating on subform (1 Viewer)

[gguy]

I figure there is a simple answer to this but I am just not seeing it.

Need some help with some fields that should be calculating on a subform.

For example, I have =nz([field1])+nz([field2]) in the control source of field3. When I tab through and enter, maybe 5 in field1 and 6 in field2 then field3 should update to 11 but it stays blank. If I click on a blank area in the subform these field3 will process the event and show 11.

I have tried a me.refresh in the gotfocus of the next field in the tab order but that didn't help.

Thanx

 

[boblarson]

You can force a recalculation by putting

Me.Recalc

in the AfterUpdate event of each control which will have numbers added.