Overdue popup message for Date Fields

[Guest]

I have 3 fields in a table (Rental Start Date & Rental Return Date, along with TransactionType - RENTAL or RETURN

Each time I enter a new record, I put in the Start Date and the Return Date for an item, along with whether the item was RENTED or RETURNED

Is it possible to have Access display a POP-UP message that informs the user if a particular item goes beyond a scheduled Return date

For example, Bill rents an item starting on May 5, 2004, 5:00 PM and plans to return it on May 10 @ 5:00 PM (5 Days). If he doesn't return the item by then (i.e. RETURN) then a POP up saying that this item has yet to be returned

Not sure if this is possible, but any feedback would be welcome

Thank you,

 

[Peter R. Fletcher]

Assuming that you don't want to page through every record every day,
you will need code which runs when you open the database that runs a
query selecting for records where RETURNED is False and ReturnDate <
Now(). If the query returns any records, a popup form with further
information can be displayed.