#ERROR on no data reports 1

[Trudye]

I am sure this question has been asked before but I could not find it in the 6 month archive.

When there are no records to be printed on a report. I have issued a msg based on the "report no data" event. But how do you get the report to either close or get rid of the #ERROR that displays. You are not allowed to move other values to the fields, I tried using a text boxes and issuing a IIF command, I also tried a docmd.close. I am out of idea. Does anyone have any good ideas?

Thanks a lot
Trudye

 

[Sturm]

As you have mentioned you have already created an error message. So the only thing left is to make 'Cancel = True' this will close the report after the user closes the message box.

Here is an example:

Private Sub Report_NoData(Cancel As Integer)
MsgBox "Error Message Here!", vbOKOnly + vbInformation
Cancel = True
End Sub


Good Luck

 

[Trudye]

There is just on word to decribe you and your advice

"COOL!!"


Thanks so much
Trudye

 

[Garridon]

Also there's a FAQ which includes one additional step.

http://www.tek-tips.com/faqs.cfm?spid=703&sfid=1594&CFID=76599408&CFTOKEN=79764415

Linda Adams
Visit my web site for writing and Microsoft Word tips:

http://www.hackman-adams.com

Official web site for actor David Hedison:

http://www.david-hedison.com