Sum af felter fejler

Is there any chance of seeing the dB?
ekspertenATsanthell.dk
AT = @

where do you get the other totals from? They seem OK!

Mail sendt, tak. :-)

Think I found problem and solution :-)
Whats happening is when the sub form isnt showing all records on one page then the Total field isnt getting update with sum(...) until AFTER
this line of code.

Getsum1 = Me!ShowTotalMatAmount_subform.Form.TotalSumAmounttxt

so TotalSumAmounttxt is EMPTY which means Getsume1 will also be empty when you run these lines of code

Me.GetValuetxt.Value = Getsum1 + getsum2
Me.Getsum1txt = Getsum1
Me.Getsum2txt = getsum2

It happens so fast that you dont see that TotalSumAmounttxt is empty, but it is.

Anyway solution(I hope) is to put a
Me!ShowTotalMatAmount_subform.Form.Recalc
BEFORE
Getsum1 = Me!ShowTotalMatAmount_subform.Form.TotalSumAmounttxt

and maybe on other sub form too

Det virker nu. Havde slet ikke tænkt den tanke, men det giver god mening, da backend ligger på et netværk som reagerer lidt langsommere end standalone versionen.

Endnu en gang fantastisk hjælp. :-)  Tak.

I also get problem here on my PC, so it isnt the backend being on a server over network which is problem.

Great it help though :-)

Dont forget to close question by accepting answer ;-)

Thanks