Access MVP (2010-2015)You don’t want your Users to open a Report that has nothing to show them, better to give them a message instead. On the Reports NoData event you can use…
Private Sub Report_NoData(Cancel As Integer)
On Error GoTo Report_NoData_Error MsgBox "No data to Display", vbOKOnly, "Report" Cancel = True Report_NoData_Exit: Exit Sub Report_NoData_Error: If Err.Number […]
1,915 total views
