Testing for records in a subform

[Dave]

I have a subform that displays a set of child records based on the current
record in the parent form.

On the parent form is a text box that displays the count of associated
records in the child form.

Some parent form records have no associated child records. If there are no
assocaited child records, the record count text box displays an error.

How can I handle this error? IOW, how can I test for the presence of
associated child records before displaying anything in the count text box?

 

[Marshall Barton]

I have a subform that displays a set of child records based on the current
record in the parent form.

On the parent form is a text box that displays the count of associated
records in the child form.

Some parent form records have no associated child records. If there are no
assocaited child records, the record count text box displays an error.

How can I handle this error? IOW, how can I test for the presence of
associated child records before displaying anything in the count text box?

How are you calculating the count of subform records??

Normally, this would be done by using a text box in the
subform's header/footer section with the expression
=Count(*). The main form text box would then use the
expression =subformcontrol.Form.subformtextbox

With that arrangement, AFAIK, you would get 0, not #Error