I setup a cascade to null relationship between two tables and would like to
hide the message that pops up when you
delete a record from the primary table because it uses the Cascade deleting
message and is confusing.

Just looking for some tips on the best way to put DoCmd.Setwarnings into the
code.

Currently I have DoCmd.Setwarnings False in the
Private Sub Form_BeforeDelConfirm(Cancel As Integer, Response As Integer)
event

and DoCmd.Setwarnigs True in the
Private Sub Form_AfterDelConfirm(Status As Integer) event

it seems to work but wondering what the best approach is?

Thanks in advance,
Mark

Been using it in a similar fashion and have had no problem till date.
--
http://panjas.org
http://www.linkedin.com/in/spanja

If the reply is helpful or is the answer, click Yes next to
Was this post helpful to you?
and / or
Did this post answer the question?


"Mark Andrews" wrote:

> I setup a cascade to null relationship between two tables and would like to
> hide the message that pops up when you
> delete a record from the primary table because it uses the Cascade deleting
> message and is confusing.
>
> Just looking for some tips on the best way to put DoCmd.Setwarnings into the
> code.
>
> Currently I have DoCmd.Setwarnings False in the
> Private Sub Form_BeforeDelConfirm(Cancel As Integer, Response As Integer)
> event
>
> and DoCmd.Setwarnigs True in the
> Private Sub Form_AfterDelConfirm(Status As Integer) event
>
> it seems to work but wondering what the best approach is?
>
> Thanks in advance,
> Mark
>
>
>