Dcount records from a filtered form

[charly.csh]

Hello everyone

I have the next question

How can I count the records I have into the field from a filtered form



The way I tried to do was with the function Dcount

My code is:
Me.Passtxt = DCount("[TotalResult]", "[qryResults]", "[TotalResult]= 'Pass'")
Me.Failtxt = DCount("[TotalResult]", "[qryResults]", "[TotalResult]= 'Fail'")

It works pretty good for the data of the query... qryResults...

But I would like that will be calculated by the currentform named "qryResultsForm"

Thanks in advance for the support!

[ranman256]

fields have brackets, not queries,
try

Me.Passtxt = DCount("*", "qryResults", "[TotalResult]= 'Pass'")
Me.Failtxt = DCount("*", "qryResults", "[TotalResult]= 'Fail'")

[charly.csh]

Thank you ranman

But it is still taking the info from the query "qryResults" and it's not taking the info from the "qryResultsForm" which is being filtered by a textbox in the form

How can I solve it?

[June7]

Textbox in form header or footer with expression in ControlSource: =Count(*)

Brackets must be used to enclose any (field, table, query, form, report) names when spaces or special characters/punctuation (underscore is exception) are used in the names.

[charly.csh]

You were right about add this on controlsource = Count(*)

I've added that to each field controlsource: Passtxt and Failtxt (Unbound) text boxes

and when I'm filtering the info it shows the quantity of records filtered in the form, but not with the criteria about the quantities of Pass' and the quantities of Fail'

Why? and how could be it fixed?

[June7]

Need IIf() expression:

=Count(IIf([fieldname]="Pass",1))

=Count(IIf([fieldname]="Fail",1))

or

=Sum(IIf([fieldname]="Pass",1))

=Sum(IIf([fieldname]="Fail",1))

[charly.csh]

Totally right!!

Thank you!