Susan Geller
sgeller at cce.umn.edu
Thu Aug 14 10:35:27 CDT 2003
XP. I have a form that opens a report. In the report, I have: Private Sub Report_NoData(Cancel As Integer) MsgBox "There are no data to display for the criteria you selected.", vbOKOnly, "DataMart" Cancel = True End Sub All's well. PROBLEM: The report cancels, and it goes back to the line right after the open report line of code. At that point, I want to evaluate to see if the report was cancelled so that I can do one thing if it was cancelled due to no data and do something else if it wasn't. How can I do this? --Susan Susan B. Geller Office of Information Systems College of Continuing Education University of Minnesota 306 Wesbrook Hall 77 Pleasant Street SE Minneapolis, MN 55455 Phone: 612-626-4785 Fax: 612-625-2568