• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 152
  • Last Modified:

Saving a total in the footer

I made a textbox in the footer to capture the total for my inputs into the blank fields...but it seems to only update when I click to save the form.  Is there any coding I can write to save (update the footer field) when I input into the blank field in the detail section?
Jass Saini
Jass Saini
1 Solution
Rey Obrero (Capricorn1)Commented:
is the textbox in the footer bound to a field?

if not, place this in the control source of the textbox

=nz(text1) + nz(text2) + nz(text3)

replace name of textbox accordingly
EirmanChief Operations ManagerCommented:
If, for example your text box is called    txtTotal
Enter this in the after update event of the form

Jass SainiAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now