?
Solved

Main Form field not changing when subform field total changes

Posted on 2013-11-07
3
Medium Priority
?
744 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 2000 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

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

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

Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
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…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

850 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