I am unable to apply a filter to a report eventhough the filter is applied to the table and query from which the report is made. I have followed all of the "Help" suggestions to no avail. Any help would be greatly appreciated.

Example:

DoCmd.OpenReport strReportName, acViewPreview, , strWhere


Where strReportName is the name of your report, acViewPreview is an option to display the report in preview mode, and strWhere is a string containing your filter criteria (similar to the WHERE part of and SQL statement but without 'WHERE')

Alex