Form validation - yes that old chestnut

[tezread]

I have two date/time fields.

Date referred
Date seen

I want to add some validation in it which says If the Date referred entered is greater than the date seen - tell the user to "Date referred cannot be entered as a date greater than the date seen"

 

[John Big Booty]

You could use some code along the lines of the following in the Date Seen field's Before Update event;

    If Me.SeenField <= Me.RefField Then
        MsgBox "Seen must be after than Referred"
        Cancel = True
    End If

 

[CBrighton]

Something like this in the date referred textbox's after update event should do it (replace my control names with yours):

If txtDateReferred > txtDateSeen Then
   msgbox "Date referred cannot be entered as a date greater than the date seen"
End If

:edit:

I forgot to include setting the field back to null, but JBB's before update & cancel is better than after update & setting back to null.

 

[tezread]

works a treat cheers guys