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
How force table update when no bound field updated? 1
Another Question on Subforms 2
subform total to mainform 2
Subform record validation 2
subform total behaving strangely 2
balance for invoice with multiple payments 2
Access Main form/Subform Navigation 0

Top