refresh information

[Jack]

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.

 

[Weeble]

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