Javy,
You didn't mention how you are going about getting the sum of this
calculated control onto your main form. But I think you will need to do
the sum in a control in the Header or Footer of the subform, and then
reference *that* control on the main form. In other words, let's say
you put a TotalWhatever textbox on the subform, with its Control Source
like this...
=Sum(IIf([PICK],Nz([DUE SHIP],0),0))
.... and then, the control on your main form like this...
=[NameOfSubform]![TotalWhatever]
If you still need more help, please give some more details of what
you've got there.
--
Steve Schapel, Microsoft Access MVP
Hello, I have this formula on the subform =IIf([PICK]=True,Nz([DUE SHIP]),0).
Now, on the main form, I want to sum the result of this condition. I keep
getting a #Error, helpppppppppppppp! Thanks all.