Joe Hecht
jmhla at earthlink.net
Wed Dec 8 00:46:41 CST 2004
The message box is OK. I am trying to kill the " The ReportOpen action was canceled box" is unwelcome. How can I make it go away. Private Sub Report_NoData(Cancel As Integer) Dim lngRetval As Long DoCmd.SetWarnings False lngRetval = MsgBox( _ "There are no products requiring a QAIP Form in for this Purcase Order.", _ vbOKOnly + vbInformation + vbSystemModal + vbDefaultButton1, _ "No QAIP for this PO") Select Case lngRetval Case vbOK Cancel = True End Select DoCmd.SetWarnings True Thanks JOE HECHT LOS ANGELES CA jmhla at earthlink.net