Message Box Based on Date Range

[MSAccessOldTimer]

I have a Search Form that returns results based on a Start and End Date. I would like to develop a custom message box based on if the "Start" and "End" Date is 5 days or more apart. I was looking at putting something in the [EndDate] validation field within properties, but am stuck on "If =>[StartDate]+5, then "message....". Should I even be looking the Validation field, or is this something that should be considered in the "AfterUpdate" event?

[orange]

Take a look at DateDfiff function
http://www.techonthenet.com/access/f...e/datediff.php

General logic

If datediff( "d",startDate, endDate) >=5 then
'do something

You might want to do your manipulation in a beforeUpdate event , so you could cancel if needed

Good luck

[MSAccessOldTimer]

Orange - good point about placing this in the BeforeUpdate event. I will give it a shot. Thanks!

[MSAccessOldTimer]

Got it working! Thanks Orange!

[orange]

Good stuff!