MessageBox if the report is Empty

[annyK]

Hello all,



after having struggled for 4 days alone I decided to post my problem here. Hopefully someone can help me!

I have a form with some blank fields for the date period (should be inserted) and an Open Report Button. The report shows some data that were modified in this period.

If there were no modifications during the entered period the opened report will contain only the header but no values.

What I need now is to insert a MessageBox "No values in this period", when the report opens and it is empty.

Therefore I created the following macro:

if IsError([Reports]![UserAdminLogReport_Japan]![Modification]) Then
MessageBox "No values in this period"
End If

This macro actually works, but only when the report is open and I click on the macro.
So my question is: What can I do if I want the MessageBox to appear directly after (or insted of) opening of the report without having to click on the macro itself.

I would be so thankful for any suggestions and help.

Thanks in advance

Anna

[Bob Fitz]

You should be able to display a message box by using the reports On NoData event. You can also cancel the opening of the report in this event.

[annyK]

Thanks! This helped!