Total from subform on form

D

Denise

I have a browse form for project information. On this
form there are subforms for estimates, costs, billing,
payments. I then have unbound controls on the main form
to display the totals from all of the subforms.

The problem is that if no cost record or billing record
has been entered yet, the control is showing #error.

How do I get the control to show 0.00 if there are no
records in costs or billing yet?
 

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

Top