stop printing nil reports

[Guest]

i have one form where i enter patients data and expenses. and i have three
reports to be printed for it.one for ticket LPO , one for advance payments ,
and one is for printing details report. i am print these three reports by
having one command button (using macro) to print for the current patient. but
sometimes there is no advance payment.in this case i want to get only two
reports . i dont want to print nil report for the advance pay. what should i
do?

 

[Linda Burnside]

You'll want to add an event OnNoData ... try something like this:

MsgBox "There are no records to print."
DoCmd.CancelEvent

Linda