Date greater than date in another field

I need a date validation that will not allow a date to be entered in
the field if it occurs before a date in another field (StartDate). But
I cannot find any information on how to do this.

Olly

re: Date greater than date in another field

Behind the field's before update event (in the form, not the table) place
the following code:

If Me![YourFieldName] < Me![StartDate] Then
Msgbox "The date you have entered is and earlier date than the Start
Date."
Cancel = True
End If

Jeff


"Olly" <oliver@olly86.co.uk> wrote in message
news:1099473976.073997.83400@f14g2000cwb.googlegro ups.com...[color=blue]
> I need a date validation that will not allow a date to be entered in
> the field if it occurs before a date in another field (StartDate). But
> I cannot find any information on how to do this.
>
> Olly
>[/color]