Reports with no records.

[uplink600]

Good Morning

I have a number of reports set up on my database. When the corresponding queries do not find any records for the reports I would like Access to display a message dialog stating that no records were found. I do not want a blank report displayed/printed.

Could you advise an easy way to acheive this.

Thanks

VC

 

[Rich]

Use the NoData Event of the Report

Cancel=True
MsgBox"There are no records to print"