Records in Report Preview and Report Print Not The Same 1

[JTheisen]

The following VB Commands to preview and print a report use the same "Selection" Criteria. The Preview command works fine in regard to only displaying records with a Quantity > 0. However the Print command prints the records with Quantity > 0. Why?

Preview Command (OK)
------------------------------------------------------------
DoCmd.OpenReport stDocName, acPreview, , "OrderID = " & Forms![Orders].OrderID & " AND QUANTITY > 0.0"


Print Command (Not OK)
------------------------------------------------------------
DoCmd.OpenReport stDocName, acNormal, "OrderID = " & Forms![Orders].OrderID & " AND QUANTITY > 0.0

 

[RoyVidar]

One reason for them to differ, is that the second statement (print), lacks a comma (making the filter the "FilterName" arguement in stead of "WhereCondition").

Roy-Vidar

 

[deduct]

Those pesky commas!

Karl