Solved

Main Form field not changing when subform field total changes

Posted on 2013-11-07
3
703 Views
Last Modified: 2013-11-07
I have a form which contains a subform.  When records are added to the subform there is a total in the footer of that subform.  The value of this total is supposed to update in a separate field on the  main form when records are added to the subform but it isn't changing.

The Main form is named frmInvoiceMaster and the field on that form which is supposed to update is named txtInvoiceTotal

The subform is named frmInvoiceDetail and field in the form's footer which DOES recalculate when records are added is named txtTotal.

How can I make the field in the main form recalculate when records are added to the subform?

--Steve
0
Comment
Question by:SteveL13
  • 2
3 Comments
 
LVL 12

Accepted Solution

by:
pdebaets earned 500 total points
ID: 39631527
The control source for the field on the parent form should be

=MySubformControlName.form!txtTotal

... where "MySubformControlName" is the name of the subform control on the parent form.

You can enhance this with Dev Ashish's nnz function

http://access.mvps.org/access/forms/frm0022.htm

Ex.:

=nnz(MySubformControlName.form!txtTotal)
0
 

Author Comment

by:SteveL13
ID: 39631554
I just discovered that the value on the subform IS NOT changing.  Why would that be?
0
 

Author Comment

by:SteveL13
ID: 39631617
Never mind.  I got that.
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Suggested Solutions

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
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 …

856 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