My Access database has an EquipmentMaster table containing field 'CurrLocHistID'. The Detail Table (LocationHistory) contains the locations that the equipment has been located, with a DropoffDate field. I need to be able to update the 'CurrLocHistID' field in the EquipmentMaster table when a record is added to the LocationHistory table that is the most current based on the DropoffDate field (tables link by SerialNumber). I was attempting to use 'Events', 'After Record Added' but really have no idea how to write the necessary code.
Any help would be appreciated!!