Access MVP (2010-2015)


Don’t Open Report if No Data…

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,709 total views