How to exclude a report from printing if it has no information in it ?


This is probably a pretty newbie question, but what I'm looking to do is this. I have a print macro that allows me to print all my daily forms with one buttom push. However, one of my reports can sometimes have no info in it and I'd like to exlude it from printing... How?



Check Online help - HasData property and NoData event.

This function is one of the possible answers to your question:

Private Sub Report_NoData(Cancel As Integer)
   MsgBox "No Data !"
   Cancel = True
End Sub


Copyright 1999-2008 by Shamil Salakhetdinov.  All rights reserved.