Hi.
I want a message box warning users that the date they entered is before a another date in the same table, but not on the same form.
I have tried in After Update, Before Update, etc. an:
If date1 < date2 Then
Me.WarningDt.Visible = true
Else
Me.WarningDt.Visible = false
End If

But it does not work.

Any ideas?
Thanks in advance.

Russ

If the 2nd date field is not on the form then you can't refer to it without using a DFunction, why can't you add the field to the form and hide it?