How Do I Set An Access Form Reminder When Time Period Has Elapsed

[3dmap1]

I have an Access 2003 database. In my database form, it shows client info for each client. I have each client set up by a status Type, A = active, N = New, F = final. I have a subform that shows when every update was sent to a client. The subform has a date field and an note field. Their relationship is the Job #.
HOW can I set the database up to send me a notice when it has been more than 10 days since the last update was sent to an active client?

 

[djj55]

One way would be to have a macro that checks every time you start the project.

 

[SeeThru]

Have a report with criteria of

Updatedate<=date()-10

Have the report run each time it is opened, and cancels using the NoDaa event if there is nothing.

You could also display a form listing the records using similar functionality.

SeeThru
Synergy Connections Ltd - Telemarketing Services