I would like to have a msgbox notification when a form opens that goes through a table that has Date field for ContractExpiration. When the date in that field is older than today I want to list the Vendor name.
So, I have a table with two fields - VendorName, ContractExpiration
The situation when the form opens would be a msgbox saying (supposing that HP and DELL have older than today dates in the ContractExpiration field):
HP, DELL have pass due contracts.
I'm not sure how simple it's to write, I don't want to use reports for this. Thanks all of you