Where clause

[Rich]

Any ideas why this statement and others like it don't work in 2010

This works

DoCmd.OpenReport "rptPerLett", acNormal, "", "[tblPerLettr]![cntLettrID]=[Forms]![frmPerLttrs]![Jobs].[Form]![cntLettrID]"

This just prints Type!
DoCmd.OpenReport "perConEnv", acNormal, "", "[tblPerLettr]![cntLettrID]=[Forms]![frmPerLttrs]![Jobs].[Form]![cntLettrID]"

 

[namliam]

Dont think it works in 2002 either...

Try something like:
DoCmd.OpenReport "rptPerLett", acNormal, "", "[tblPerLettr]![cntLettrID]= " & [Forms]![frmPerLttrs]![Jobs].[Form]![cntLettrID]

 

[Rich]

Thanks but for some strange reason it's now working even though I haven't changed anything