Is there a way to have VBA check the table to see if the data has changed? For example, if the table today contains
First Name Last Name ItemPurchased WarrantyPurchased SalePrice
Mike Mike Oven No 400
Jay Jay Freezer Yes 2200
Rich Rich Hair Dryer No 60
But tomorrow the table reads:
First Name Last Name ItemPurchased WarrantyPurchased SalePrice
Mike Mike Oven No 400
Jay Jay Freezer Yes 2200
Rich Rich Hair Dryer Yes 120
Could you programmatically detect that change? There is no form, so I can't use an afterupdate() Event which is what I was hoping for.