[AccessD] Report Cancel Issue

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





More information about the AccessD mailing list