Where Clause in OpenForm statement

I am having trouble with the where clause in an openreport statement in an
Access Data Project.

I am using MS-Access 2003 with SQL Svr 2000.

The line I am using is:

DoCmd.OpenReport "rptAllRecords", acViewPreview, , "[active]=" 'True'

When I hit the button that is supposed to open the report I get the
following error:

Run-Time error '30025':
Invalid SQL Statement. Check the server filter on the form record source.

I have built the report directly form the table, not from a sql statment or
view.

Does anyone know what the problem is?

Thanks,
Mike
m charney at dunlap hospital dot org



.

Quantcast