Prev: Update Text Box
Next: Combo box to find a record in Access 2007
From: Jack on 20 Nov 2009 21:15
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
From: Weeble on 25 Nov 2009 13:02
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



"Jack" wrote:

> 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
 | 
Pages: 1
Prev: Update Text Box
Next: Combo box to find a record in Access 2007