I have a total in a subform form footer that creates a null value if there is no record associated with it and I keep getting the #Error when I try to total the equation below in my parent form. I still need it to change the null to a zero in the equation so it will compute. I used the Nz function but still get the error.
=[Qty]-Nz([InvenPull subform Ord Proc].[Form]![Text4],0)