Here is a quick solution that usually works for me.<br><br>Use the SaveRecord command before closing the update form that is based on Table C. Here is the code.<br><br>DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70<br><br>Chances are you have a button to close...