Need subform total on main form ?

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"
 
G

George

Dear,

Use the Nz (not zero) function.

GeorgeCY

Ο χÏήστης "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

Similar Threads

referring to Subform Total in main form 1
Populate main form from subform record 0
How force table update when no bound field updated? 1
main form/subform 1
Another Question on Subforms 3
subform total to mainform 4
Subform record validation 2
Referring to control in the active subform 0

Top