Newbie -Working with dates-HELP!

[Tracey]

I'm working with a form that has a (date to return by) field. Is there any way to alert me when the date is past due? I have tried inserting a command button on the form based on a querry using the DateAdd function, but am having trouble building the querry. ANY help would be greatly appreciated.

 

[fredg]

I'm working with a form that has a (date to return by) field. Is there any way to alert me when the date is past due? I have tried inserting a command button on the form based on a querry using the DateAdd function, but am having trouble building the querry. ANY help would be greatly appreciated.

Would simply changing the control's color be an alert enough?
No command button, no DateDiff needed.
Code the Form's Current event:

If [DateReturn]< Date Then
[DateReturn].BackColor = vbRed
Else
[DateReturn].BackColor = vbWhite
End If

You could also use conditional formatting if you are using Access 2000
or higher.