Syntax error - missing operator for OpenReport

[buskgrim]

DoCmd.OpenReport "R:Test Report", , , "School =" & MyField

The above reults in "Syntax Error (3075) missing Operator in query expression"

The field variable is correctly picking up the values I want but the OpenReport method refuses to run (I am simply attempting to cycle through a dataset and print a report for each record).

Any help gratefully received!

Thanks

Chris

 

[danvlas]

Are you sure MyField is numeric? If it's text, enclose it between single quotes:

DoCmd.OpenReport "R:Test Report", , , "School ='" & MyField & "'"

HTH,

Dan

 

[buskgrim]

Dan,

OpenReport problem solved.

Much Appreciated.

Chris.