Continuous form Count in the header Null records Blanks out count not 0 (I used Nz)

[crimedog]

Continuous form based on a query.
In the header I have some Count functions (which work correctly) and some texts with DCount counting a separate table - these also work.
I have some combo boxes that filter the query - these work


when I choose an option that cause the query to be NULL - thus the records on the form are NUll

The text boxes with:

=Nz(Sum(IIf(IsNull([FulfillNumber]),0,1)),0)

go blank - I have also have

=Nz(Count(IIf(IsNull([SalesOrder]) And [ApprovedByPaas]=False,1)),0)

AND the text boxes with DCOUNT (which should be unaffected by the Combo Boxes) go Blank

Obviously something is screwy - but I don't see it

[pbaldy]

I think you're running into this:

http://allenbrowne.com/casu-20.html

By the way, the records on the form aren't Null, there are no records. This would work if a subform:

http://www.theaccessweb.com/forms/frm0022.htm

[crimedog]

Exactly the case - My form is returning no records because of filter & is read only because it is the result of a Union query - I will take the suggestion and add the Message box.

Thanks - It is good to know the cause.

[pbaldy]

Happy to help!