count records in subform with criteria

[referee]

hi

on my mainform i used this syntax in a textbox

Me!Text93 = Me!frmSuboverzicht.Form.RecordsetClone.RecordCount

this count my records and works fine

what i want to do is count the records in the subform with a creteria
and show on the mainform only the records with the status "OK"

the subform is bounded with the query "qryFinal"

can someone help me with this syntax

thanks

 

[pbaldy]

You could use a DCount on the query, including your criteria. More on syntax:

http://www.mvps.org/access/general/gen0018.htm