Forms :: Give Warning When Switchboard Form Opens?

I have a table which holds information relating to a fleet of vehicles; each of these vehicles is currently physically checked on a daily basis for a number of items, one of which being to check that the vehicle has valid VED (tax disc).

With the paper disc being abolished now, we have a situation where the individual using the vehicle cannot be certain about its VED status (the chances of one not being taxed is next to nil, but we are talking a fleet of nearly 1000 vehicles here, so anything is possible)

Our current database has most of the vehicle information stored already, so in theory I think I only need to add a couple of fields, which will make the table structure (roughly):

FleetID
RegistrationNumber
CallSign
MobileTelNo
MOTExpiry
VEDExpiry

With the latter two being the added fields.

Now, what I was wondering.....

Is it possible that when a Form (not related to the table, and most likely the main switchboard form) is opened that both the MOTExpiry and VEDExpiry dates are checked, and if either or both of them are due to expire within 7 days or have already expired that a warning appears (vbaOKOnly messagebox would do fine) stating that there are vehicles that require their MOT & VED dates to be checked and updated accordingly)?