One Date Field Later than another Date Field

[JohnL7]

Hi All,

I have a form with six sub-forms. On one of the sub-forms is a date field (DATE1) which is automatically filled with the date the record was created. On another sub-form is another date field which is filled by the user (DATE2). When the user enters a date in DATE2 I want that date to be automatically checked against DATE1. If DATE2 is earlier than DATE1 I want a message box to be opened informing the user that they must choose a late date.
I've tried various ways but seem to be going around in circles. Any ideas please.

Many Thanks

John

 

[pbaldy]

I generally do all validation in the before update event of the form:

http://www.baldyweb.com/BeforeUpdate.htm

though you could do this in the before update event of the textbox if you wanted.

 

[JohnL7]

Many Thanks Paul, that worked like a charm!!

John