report from a sub form help

[andywhittle]

Hi

Can anybody else.

Refering to gromits database example

http://www.access-programmers.co.uk/forums/showthread.php?t=99353

I am trying to import the subform table into a report. I have tried

Dim stDocName as variant

stDocName = "Invoice Query"
DoCmd.OpenReport stDocName, acPreview, WhereCondition:=BuildFilter

This works ok if i want everything in the report, but if i change any of the variables i get:

Sytax error (missing operator) in expression

The build filter works ok normally when doing a search tho

Thanks for any help