Need subform total on main form ?



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"



Use the Nz (not zero) function.


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question