DoCmd.PrintPreview.......

[gpurger]

Please help
I have the following statement in a 'Select Case' and I get a blank result.
DoCmd.OpenReport "RptAll", acViewPreview, , "Sub System" = Forms![FrmPrintReports]![LstSelectSub]

Where am I going wrong

Cheers

Gordon

 

[richary]

Try

DoCmd.OpenReport "RptAll", acViewPreview, , "Sub System =" & Forms![FrmPrintReports]![LstSelectSub]

 

[gpurger]

richary,
I think I may have mislead.
"Sub System" is the field I want to filter on the report "RptAll"
and Forms![FrmPrintReports]![LstSelectSub] is the criteria.

Cheers

Gordon

 

[gpurger]

Cheers for that, already incorporated.

Gordon