?
Solved

Saving a total in the footer

Posted on 2014-12-23
3
Medium Priority
?
138 Views
Last Modified: 2014-12-24
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?
0
Comment
Question by:Jass Saini
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 2000 total points
ID: 40515225
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
0
 
LVL 24

Expert Comment

by:Eirman
ID: 40515232
If, for example your text box is called    txtTotal
Enter this in the after update event of the form

Me.txtTotal.Requery
0
 

Author Closing Comment

by:Jass Saini
ID: 40516806
Thanks
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question