Subform with no records

[Bamstick]

I have a form with an embedded subform, which, depending on the query result, may or may not have records. I have a field on the main form that points to a calculated field on the subform. When the subform has records, all is well as the calculated field exists and updates the field in the main form. However, when the subform query results in no records, which can occur often, the field in the main form contains "error". This creates errors in the rest of the fields that require this field in calculations. How do I program the field in the main form to result in "0" in the case where there are no records in the subform? Thanks much in advance to this assistance.

[RuralGuy]

I believe this link is the page for which you are looking.