Update (Refresh) Calculated Field

[libraccess]

I have a subform which refers values to controls on a form on which I have a calculated field -
originally I used CalculatedField Type then I changed it to txtBox with Number as Type
Control Source =[field1]+[field2]+[field3] Now the calculated field does not show anything until all the controls have an entry. Sometimes (most times) not all will have entries. I put a form refresh on the main form but still no value. So then I did Me.Recalc on the AfterUpdate of the Main Forms Controls Then I did Me.DelTotal.Recalc And a refresh button in the subform, just nothing until all the controls in DelTotal Control Source hav an entry????
Any clues anyone

[R_Badger]

I'll give you an analagy as to why it isnt working

I'm going to give you three numbers to add together.

1, 2

Whats the answer? I hope you are thinking 'I can't tell you, you never gave me the third number' because thats exactly whats happening with access, it is waiting for the third number before it returns your answer.

you need to do =nz([field1],0)+nz([field2],0)+nz([field3],0)

The nz function checks to see if the item is null, and if it is, returns the number after the comma.

See here for a bit more on nz

http://office.microsoft.com/en-us/ac...001228890.aspx

[libraccess]

Apologies for delay in getting back, away until today. It works, but of course you knew that

Many thanks