Solved

Saving a total in the footer

Posted on 2014-12-23
3
111 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
3 Comments
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 500 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 23

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

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

705 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now