How to filter selected records in a report?

[eneyardi]

How to filter selected records in a report?
for example: i have a form name ADM List, the default view is split form so that i can view all the records. my report name is ADM Report. in ADM List i have a field names; subject and status. in a status field, i have a records of two pending and done (i have two option to put in a status field that is pending and done)
for example that i want to filter the status field to done so that all records contains done can only view. it easy to do these in my ADM List, but i want this filter to be effect in report when i click my command button print report.

[jimatqsi]

This code will open the report in normal mode (use acPreview for preview) using the criteria you asked for.

dim strCriteria as string
strCriteria = "[status]='Done'"
docmd.openreport reportname, acNormal, strCriteria

Jim