Validation In Access?

[shpud]

I'm trying to create a validation rule that will only allow a date after the date entered in a previous field.

For example.
I have 2 fields, 'Date Start School' and 'Date End School'
How do I create a validation rule that makes sure 'Date End School' is after 'Date Start School'


I don't know whether that makes sense to anyone, but any help would be appreciated.

Thanks in advance

[nico5038]

To test multiple fields I don't use a validation rule, as it's not sure which field will be filled first...
You need to know that the user is finished entering data before testing, that's why I always have a [Save] button to do all the testing. My code "behind" that button looks like:

Private Sub btnSave_Click()
Dim txtMessage As String
On Error GoTo Err_btnSave_Click
    ' init error message 
    txtMessage = ""
    ' Check fields in reverse order to set focus to the first
    If Not Len(NZ(Me.Description)) > 0 Then
        txtMessage = "Description empty ?" & vbCrLf
        Me.Description.SetFocus
    End If
    If Not Len(NZ(Me.Severity)) > 0 Then
        txtMessage = "No Severity?" & vbCrLf & txtMessage
        Me.Severity.SetFocus
    End If
    If Not Len(NZ(Me.Type)) = 0 Then
        txtMessage = "Recordtype empty ?" & vbCrLf & txtMessage
        Me.Type.SetFocus
    End If
    ' Check error found
    If Len(txtMessage) > 0 Then
        MsgBox txtMessage
        Exit Sub
    End If
 
    DoCmd.Close
 
Exit_btnSave_Click:
    Exit Sub
 
Err_btnSave_Click:
    MsgBox Err.Description
    Resume Exit_btnSave_Click
 
End Sub
 

Here you can test first or both fields are filled and when they are, test for their relation.

Clear ?

Nic;o)