IS NOT NULL in validation

[DAHMB]

I have a form with a field called ClearanceCode, I want to create a validation rule for it that requires that if another field called DateClosed has a date entered that the data in the ClearanceCode field can not be "Open". Something like:

IFF(IS NOT NULL[DateClosed] <>"Open")

I know I am way off. Any help would be appreciated.

Thanks'
Dan

[Nathan H]

I have a form with a field called ClearanceCode, I want to create a validation rule for it that requires that if another field called DateClosed has a date entered that the data in the ClearanceCode field can not be "Open". Something like:

IFF(IS NOT NULL[DateClosed] <>"Open")

I know I am way off. Any help would be appreciated.

Thanks'
Dan

I have something similar on a dependent field in a form. Perhaps this will work, I put this code in the AfterUpdate event property of the first text box:

Private Sub Text1_AfterUpdate()
Me![Text2].Requery
If Me![Text1] = Null Or Me![Text1] = 0 Then
    Me![Text2].Visible = False
Else
    Me![Text2].Visible = True
End Sub
 

[ADezii]

I have a form with a field called ClearanceCode, I want to create a validation rule for it that requires that if another field called DateClosed has a date entered that the data in the ClearanceCode field can not be "Open". Something like:

IFF(IS NOT NULL[DateClosed] <>"Open")

I know I am way off. Any help would be appreciated.

Thanks'
Dan

Here is an example of how you can validate entries in these 2 Fields at a Form Level. Place the code in the BeforeUpdate() Event of the Form.

Private Sub Form_BeforeUpdate(Cancel As Integer)
Dim Msg As String
 
If Not IsNull(Me![DateClosed]) And Me![ClearanceCode] = "Open" Then
  Msg = "The Clearance Code Field cannot contain the value Open if the "
  Msg = Msg & "Date Closed Field contains a valid Date." & vbCrLf & vbCrLf
  Msg = Msg & "This Record cannot be Saved!"
    MsgBox Msg, vbExclamation, "Field Validation Error"
      Cancel = True     'Cancels the Update to the Record
End Sub

[lee123]

are these field both text boxes? need more information on these field for instance:

ClearanceCode :

what do you mean by "open"
because when you say open this could be form or a subform?

lee123

[DAHMB]

are these field both text boxes? need more information on these field for instance:

ClearanceCode :

what do you mean by "open"
because when you say open this could be form or a subform?

lee123

Open is my term for if the case is open or closed it has notheing to do with the code. and they are text boxes and the DateClosed is formated as a date.

Thanks for any suggestions

[DAHMB]

Thank you everyone
I ended up using Adazii suggestion which worked perfectly. Thanks again.