I don't get that but try wrapping your cancel command with a SetWarnings command like so...
DoCmd.SetWarnings False Cancel = True DoCmd.SetWarnings True May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at ==> http://www.prodev.us ________________________________ From: luvmymelody <[email protected]> To: [email protected] Sent: Friday, February 27, 2009 11:56:31 AM Subject: [ms_access] Reports on NoData question Hello All, I have a question about the nodata cancel procedure. I have the following code in the on no data event Private Sub Report_NoData( Cancel As Integer) Cancel = True MsgBox "There are no pending Leaves today" End Sub It works well, except how do i get the "The OpenReport action was canceled" msgbox to not appear? Jim Wagner [Non-text portions of this message have been removed]
