[AccessD] filtering a subform

:)

Susan H. 

    Here is a solution that is absolutely code-less. In the source query for
subform, have a calculated field named Status (SQL given below).