I have a table used to enter the last date a project was updated.

When updating via a form, I need to compare the new date against the
last date in the record.  If the difference is greater than 14, I need
to display a message box alerting the user.  Secondly, they must then
enter comments in the comment field explaing the varience.

I'm not sure how to get the last value and compare it to the current
value.  

Any help would be greatly appreciated.  

Thank You,

Jimmy