Report extract from subform field

[aattas]

Hello,
I have a continuous subform in a main form and Im trying to produce a report to only accept if one of the field of the subform data (field) equals " active" .

How do write the code if i click the printing button.

 

[Ranman256]

the report query will view the item in the subform as the criteria....
select * from table where [id] = forms!myForm!subForm!form!txtBox

 

[SteveSchapel]

I think you will need to provide a bit more detailed explanation in order to get good advice! But if I understand your quesion, it will be something like this...

If Me.NameOfSubform!Field = "active" Then
DoCmd.OpenReport "YourReport"
End If