Solved

Main Form field not changing when subform field total changes

Posted on 2013-11-07
3
693 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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
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 retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

773 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