Stop Record from being inserted

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I have 3 controls on a form in an ADP. If the 2 controls equal a
certain combination and the 3rd control is null, How can I stop the
record from being inserted?
 
On Fri, 17 Jul 2009 17:34:36 -0700 (PDT), Dave

This is validation code that belongs in the Form_BeforeUpdate. If the
condition occurs, set Cancel to True and the insert will not happen.

-Tom.
Microsoft Access MVP
 
I have 3 controls on a form in an ADP.  If the 2 controls equal a
certain combination and the 3rd control is null, How can I stop the
record from being inserted?
Click to expand...

In the BeforeUpdate event of the form use something along these lines
(untested air code)

If control1 = "value" and control2 = "value" and isnull(control3)
then
docmd.cancelevent
msgbox "Whatever error message you wish to use."
end if

Keven Denen
 
Perfect...Thanks guys! (B)(B)








In the BeforeUpdate event of the form use something along these lines
(untested air code)

    If control1 = "value" and control2 = "value" and isnull(control3)
then
        docmd.cancelevent
        msgbox "Whatever error message you wish to use."
    end if

Keven Denen
Click to expand...
 
Back
Top