Hello all,
I have a Print button on a form that has an OnClick event:
DoCmd.OpenReport "ILP_017", acViewNormal
DoCmd.OpenReport "ILP_017a", acViewNormal
DoCmd.OpenReport "ILP_022", acViewNormal
Each report data source is an SQL query.
Problem:
When one of the queries returns zero records the report still prints blank with a number of #Errors in various fields.
Goal:
I just want reports to print when there are records returned by the query.
How do I accomplish this?
Thank you,
Manny64
I have a Print button on a form that has an OnClick event:
DoCmd.OpenReport "ILP_017", acViewNormal
DoCmd.OpenReport "ILP_017a", acViewNormal
DoCmd.OpenReport "ILP_022", acViewNormal
Each report data source is an SQL query.
Problem:
When one of the queries returns zero records the report still prints blank with a number of #Errors in various fields.
Goal:
I just want reports to print when there are records returned by the query.
How do I accomplish this?
Thank you,
Manny64