List boxes, Combo boxes...

[fateyes]

Hi,

I am using the Contact Management template provided by Access, but want to make a few changes....



How could I set up an alert system within it to display to the user who needs to be called? I guess I would need a new field to type in when they need to be called back (date and/or time) and then some sort of macro to display those contacts that should be called on a particular day or time...

Thanks for any help

Fateyes

 

[Dembrey]

Hi,

Sound to me that what you need to do is set up a query where the criteria is [call_back] <="Today's date".

Then when you start your database use a DCOUNT to determine the number of over due 'call backs' and display the list if it is >0.

HTH,
Dembrey.