WhereCondition ignored when MS Access Form invokes Report

I have a form with fields, and a button, whose onclick opens a report,
using:

DoCmd.OpenReport myReportName, acViewPreview, , myWhereCondition

All is well: the report opens, and the parameters from the form appear
correctly in the report header.

However, the myWhereClause achieves nothing, and fails to cause the
appropriate records to be filtered out of the report. Any ideas as to
why?

The whereCondition is simply "fieldName = 222222". Please note that I
ran a query with the exact same whereCondition (SELECT * FROM tableName
where fieldName = 222222"), and there, it does work.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

"yisraelharris" wrote in message
...

I have a form with fields, and a button, whose onclick opens a report,
using:

DoCmd.OpenReport myReportName, acViewPreview, , myWhereCondition

You have one comma missing in the above.

DoCmd.OpenReport myReportName, acViewPreview, , , myWhereCondition