Access MVP (2010-2015)

oOo.oOo.oOo.oOo.oOo.oOo

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