[AccessD] how to have access ignore a form that is canceled

[Jim Dettman]

Bill,

  With the VBA editor window open, click on tools/options.  Click the
general tab.

  Make sure your selected to break on unhandled errors.

Jim. 

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Bill Benson
Sent: Monday, July 27, 2015 03:38 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] how to have access ignore a form that is canceled

I am running this

DoCmd.OpenForm "frmComments", acNormal, , , acFormEdit, , CStr(Me.ID)

When the openargs is null, I cancel form load.

How can I get Access to ignore that the form wont open instead of throwing
me into break mode?



My error trapping is not working, and the problem arised before Form_Error
in the calling form so I cannot continue past it (which makes sense since
it is not a data error I guess).

Private Sub cmdAddComment_Click()
On Error Resume Next
DoCmd.OpenForm "frmComments", acNormal, , , acFormEdit, , CStr(Me.ID)
If Err.Number <> 0 Then
    MsgBox "Could not open the comments form"
End If
End Sub
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com