Filter and Print Report

[fenhow]

Hi, I am using this to filter a report and print preview. The question I have is how can I print all the records if the value in txtStatus is null?
Many thanks.
Fen

DoCmd.OpenReport "CAM AVAILABLE INVENTORY REPORT", acPreview, , "Status= '" & Me.txtStatus & "'"

 

[pbaldy]

Test it with an If block and open it without the wherecondition if it's null.