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

[Bill Benson]

Yes, that setting is there.

The problem as I see it, is that Access doesn't like me to cancel a load of
a form when there was a calling routine that opened it. My feeling is, so
what? Thats the idea. There ought to be a way to trap for that and
disregard I have forbidden the form to open by design!

On Mon, Jul 27, 2015 at 4:24 PM, Jim Dettman <jimdettman at verizon.net> wrote:

> 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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>