Need subform total on main form ?

  • Thread starter Thread starter mscertified
  • Start date Start date
M

mscertified

I have a form containing a subform. The subform lists payments. I need to
display on the main form a total of the payments in the subform. The current
controlsource is working except when the subform is empty (no payments exist)
it displays #Error. How should this be done? Also, is the current event the
correct place to set this controlsource. Thanks.

Here is how it is set up now: the subform has a Payment control and a
TotalPayments control (set to =Sum(Payment)). The main form has a control
with controlsource "=TotalPayments"
 
Dear,

Use the Nz (not zero) function.

GeorgeCY

Ο χÏήστης "mscertified" έγγÏαψε:
 
Back
Top