Calculate Date Difference and display message box

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

jbsfe wrote:[color=blue]
> 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[/color]

DMax("DateField", "TableName", "Criteria (if needed)")

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com