90 day customer reminders

[Jo]

I am attepting to set up a new database. I would like to know how to set up a reminder that 90 days ago I was out on a service call to a certain customers home, and its time to get in contact with them again
How do I do that

 

[losmac]

In autoexec macro or Form_Load procedure you need to test today and some date, for ex

dim dToday as Date, dSomeDate as Dat

dSomeDate = CDate("05/05/2004"
dToday = Dat

If CLng(dToday) - CLng(dSomeDate) >90 the
'..
' here - place your reminde
'..
End I