Code help with IsNot( ) operator

Tech-Archive recommends: Fix windows errors by optimizing your registry

I have an event procedure on the exit of my sub form

CODE:
____________________
Private Sub LABORDETAIL_Exit(Cancel As Integer)
If Me.NULLSUM = 0 And Me.Status = "OPEN" Then

MsgBox "HEY!!!! YOU NEED TO CHANGE THE STATUS TO - COMPLETED!!"

End If

Me.Status.SetFocus
End Sub
_____________________

Works great when the status is "OPEN"

When make the following change to the second line of code...

If Me.NULLSUM = 0 And Me.Status = "OPEN" Or "Out On Proof" Or "At
Printer/Production" Or "On Hold" Or "Waiting on Someone Else" Then



I breaks!!!


I have also tried...

If Me.NULLSUM = 0 And Me.Status = IsNot("Completed") Then


What am I missing?
.

Relevant Pages

  • Running a query and if successful run another
    ... to exit the code. ... Private Sub CmdAppend_Click ... MsgBox "There is a problem with duplicate Social Security Number or ...
    (microsoft.public.access.formscoding)
  • Re: Stopping movement away from a form control ?
    ... You can prevent the user leaving the control simply by canelling the Exit ... Private Sub MyControl_Exit ... > away from the control to the control which was clicked on once the msgbox ...
    (microsoft.public.access.modulesdaovba)
  • Re: Can DMax Statement be added to Where Statement?
    ... person doing the data entry. ... Private Sub Form_Current ... the table that corresponds to the sub form. ... this parent record, and then figure out what the highest ...
    (microsoft.public.access.formscoding)
  • Re: allow edits in sub form
    ... Private Sub Cmd_Edit_DblClick ... sub form name is Frm_Billlog_Sub ... You should use the Click event rather than DblClick for a button. ... AllowEdits property of the subform is set to False (it needn't be, ...
    (microsoft.public.access.forms)
  • RE: Combo box connections in a sub form
    ... record source of the second combo box. ... Private Sub cboAuthors_AfterUpdate ... > I have a Main Switchboard form which points to a sub form. ... > have the user choose a plan name. ...
    (microsoft.public.access.forms)