An Access report with no data has no purpose and confuses users. When an Access report has no data to report, circumvent it and display a message that tells users why you're doing so.
Private Sub Report_NoData(Cancel As Integer)
MsgBox "There's no data to report.", vbOKOnly, "Error"
Cancel = True
End SubBe sure to save the form after adding the code. When users open the report with no data to report, Access will display a meaningful message. (You can use whatever message you like, of course.) Users don't accidentally print useless reports or call you in a panic wanting to know what's wrong with the report.