>Anyone try to cancel a report using the NoData event? I am calling
>a report via DoCmd.OpenReport ...
>
>Then I am attempting to use the Nodata event and set the Cancel arguement to True. The message box states OpenReport action was canceled. Something about clicking the Cancel button in a dialog box. I remember having a similar problem with sequencing of events in a data entry form and using the unload event. Any help is appreciated. tia - Steve
I figured I should post one simple solution in case anyone else runs into this problem... I created a macro called CancelReport with two items: Msgbox and CancelEvent. Next I set the NoData Event within the report to the macro CancelReport. Finally, within the report selection form, I modified the error handler to trap for the error 2105 which was being produced after canceling the report. It works! Since I am under the time crunch, I need to proceed. If anyone has any other comments, please add them. taul
Steve
Steve Medvid
Systems Analyst
Environmental Resource Management