Count showing #Error instead of 0 on form

[jcfraun]

I have a text box on a form that counts the number of records in a subform using the following expression
=[Form]Form!Text10, where Text10 refers to a text box with
=count([Field]) in the form's footer. It works well, except when the value is 0. Then it gives me an #Error. Any ideas?

 

[RuralGuy]

Try:
=[SubFormControl].FORM.RECORDSET.RECORDCOUNT
...instead.

RuralGuy (RG for short) aka Allan Bunch MS Access MVP acXP winXP Pro
Please respond to this forum so all may benefit