Pass subform filter to a report

[dinorbaccess]

Hello AccessForumers,



I have a problem which seems to be an easy task but I cant figure it out by my own, so heres my question:

I have a subform with records. From the records of this subform Ive created a report. And I can print this report. So far, all OK.

But when I filter my records in my subform (datasheet view) and I want to print them, it prints all the records of my subform source. Of course I can filter then a record with access filter tools, but I want to pass the filter of my subform on a button_Click.

Can anyone help me do that...

Be sure I appriciate all your sugestions.... Thank you all.

here you have an example of my problem. Lets say I want to filter all my Persons that dont have a TelephoneNumber inserted, and the print them in a mouseclick button.

[dinorbaccess]

Please guys , I really need this to finish my project.

[dinorbaccess]

ANY sugestion.... Just replay please !!!!!

[dinorbaccess]

Ive got it solved fellas.

Is just this line of code

 docmd.openreport "rptWhatever",acViewPreview, , me.subform.form.filter

Thnx everybody