refresh information

  • Thread starter Thread starter Jack
  • Start date Start date
J

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.
 
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
 
Back
Top