Subform calculation error until data entered.

[knh2r]

So I have a total field in my orders subform that uses an expression to find the total. Each line item price is an expression calculated using a dmin function so this is done in a query. The total is then found by dsum from the calculations query where order ids are equal. Works great except that it shows error until some character is entered on as a new line item on the subform. It can even be a space. Also works if I navigate away from the order record and back to it or if I click to select the next to last line item in the order. But when entering a new item it's error until one of those things happen. This has given me a fit and the logic behind when it happens makes me think it's a relatively easy fix but I haven't been able to get it.



Any ideas?

Thanks!

[RuralGuy]

Are you using the Nz() function? You should be.

[knh2r]

I've used it in various positions, but have yet to find the correct one...:/. What can I do to diagnose where it should be. And would anything go in the second variable?

[RuralGuy]

What is the "expression" you are using to get the sum? You have a Form/SubForm arrangement, right? Why does it require a DMin() function? There may be a much easier way to get what you need.