Does HasData work in foms?

M

Meg

I am referencing a field in a subform, and when the
subform contains no data, I get #Error.

I have tried to replace the error with a "0" using
HasData, but with no success.
=iif([subform].form.hasdata=true,[subform].[field],"0")

Access looks for a field called "HasData".

Any other suggestions?
Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IIf function ....HasData 1
Totalling Subforms 5
#ERROR - Pulling my hair out 6
HasData property for a subform?? 10
Errors in Report total fields 19
Total Field on Form using Subform Total Field Value 10
HasData variable not defined 1
SynNeed to account for null values in subreports 2

Top