How do I can check for empty subforms

[Accessme2]

Hi everyone,
I am using Access 2002, windows XP Sp3

I have a question.. I have a form with 4 subforms... depends what is on the main form some of the subforms would be empty. so I need to add the totals on each subform but when some of the subforms are empty I get and #error...
How can I check if the subform is empty and set a value so I can added....

Thanks
AMD2800

 

[Kryst51]

What are you using and where to add the subform totals?

 

[pbaldy]

I use this:

http://www.mvps.org/access/forms/frm0022.htm

 

[Accessme2]

I just want to show on the main form the grand total by adding the subtotals of each subfrom, but like i said sometimes some of the subforms have no data so I couldn't add the total because of the #error. But the function works great..!
Thanks guys I really appreciate the help.