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

[Bob Walsh]

Doesn't it make more sense to not open the form if the argument you want to send is null?

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

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
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
IMPORTANT NOTE: The information contained in this message may be privileged, confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately and delete this message from your computer. Acumentra Health.