I am having a problem with the SUM function that displays my recipie amounts in a subform.
Ive tried different things such as
=nz(Sum([Line Total]))
in the subform
any suggestions?
I've encountered the same problem. I'd query the subform for a total after leaving it. I think the problem may be with the current record on the subform doesn't update until you move to another record or leaving the subform.
