Count showing #Error instead of 0 on form 1

[jcfraun]

I have a text box on a form that displays 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?

 

[TheAceMan1]

How are ya jcfraun . . .

Try:

[blue]=Nz(count([Field]))[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[jcfraun]

Thanks TheAceMan1, but that didn't work this time. The error remains....

 

[danvlas]

=iif(iserror(count(field), 0, count(field))
I assume this happens when the recordset is empty.

HTH


Daniel Vlas
Systems Consultant

 

[TheAceMan1]

jcfraun . . .

Rereading your post origination I find that

[blue]=[Form]Form!Text10[/blue]

makes no sense (I'm truly surprised no error is raised period!). Try the following ([blue]you![/blue] substitute proper names in [purple]purple[/purple]):

[blue]=[[purple][b][i]subFormName[/i][/b][/purple]].[Form].[recordset].[RecordCount][/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[jcfraun]

Danvlas - Thanks! That worked. I ended up having to use the ISERROR in the text box on the main form, but we have success.

TheAceMan1 - I'm new to this whole Access forum thing! It really did make sense - probably just my post that was confusing.

Thanks!