Date Validation Problem 3

[DanAuber]

I have a table with two dates in it (Start and End) - I also have a form where people can enter Data and then hit a button which uses the data in the form to update records in the table via a query.<br>I want the update to check that End date (if entered) is always later than Start date - any ideas<br>Please be Gentle<br>Dan <p>Dan Auber<br><a href=mailtoanAuber@aol.com>DanAuber@aol.com</a><br><a href=

http://members.aol.com/_ht_a/danauber/myhomepage/>Dan

Auber's Home Page</a><br>

 

[Cornerstone]

Use the Before Update event of the End Date field:<br><br>If [enddate]&lt;[startdate] then<br>&nbsp;&nbsp;msgbox &quot;Duh..End date must be after start date!&quot;<br>&nbsp;&nbsp;Cancel=true<br>End If<br>