I have a form with a subform. on the subform I put a text field that sums some fields. On the main form I put a text field that shows the result. Everything works fine when i move off of a record in the subform. I would like for it to upgrade the amount in the main form when I move off of a field in the subform. -- Thank you, Jack
Jack, I had a similar problem and used the following code in the Lost Focus event of my control. 'Update the menu with the new values, (Refresh). DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70