OpenReport WHERE Condition Not Working

[altemir]

The WHERE condition in the following code is producing a blank report with no data. How can this possibly be? Note that JobID is an integer field in the report's recordsource.

DoCmd.OpenReport "rptProductionOrder", acViewPreview, , "JobID = 10"


********** PROBLEM SOLVED ************



Underlying query for the report had an inner join instead of a left join, which restricted available records .... I feel foolish

[Robeen]

You should mark this as solved so that it doesn't show as no one replied and still open.