Question about Microsoft Office Standard for PC

# Linking Calculated Totals from subforms to the main form.

I have a hard problem linking the above subject. The main forms as Customers with sub-forms of CustomersOrder & CustomersPayment. I have created 3 txt boxes to accomodated; TotalPayment, TotalOrders & Current Balance with the ff: property control source of the ff: TextBox Name: txtTotalPayments Control Source: =Nz([sbfPayments].[Form]![txtPayments]) Format: Currency TextBox Name: txtTotalOrders Control Source: =Nz([sbfCustOrders].[Form]![txtItemsTotal]) Format: Currency TextBox Name: txtCurrentBalance Control Source: =Nz([sbfCustOrders].[Form]![txtItemsTotal]) - Nz([sbfPayments].[Form]![txtPayments]) Format: Currency And the return value is "#Name?" Please help me figure it out? Thanks. Raul L. Cadosales raberchael@yahoo.com

Posted by on

• Level 2:

An expert who has achieved level 2 by getting 100 points

MVP:

An expert that got 5 achievements.

Guru:

An expert who has written 7 tips or uploaded 3 video tips

Mentor:

An expert who has written 3 tips or uploaded 2 video tips.

• Expert

Hi Raul from your description it is very unclear what you are trying to do. First we need to know what information is on the first form, second unless you are trying to do a subtotal of all orders in the subform there is no real need for you to create a subform. Now if you are trying to create a subtotal form for all records, you will have to set it up in the record source of that subform with group by: 1. Right click on an empty space on the subform 2. Click on properties 3. Choose your table(or query) which is the record source of the main form. 4. Select Payment and items(or what ever you are trying to calculate). 5. Press the group by button 6. In totals instead of group by choose sum. 7. Exit and save 8. Now when you will select the control source you will see "sumofpayment" etc... just select them for each textbox. 9. To create the third text box you will have to use the Expression builder and just do [textbox1]-[textbox2] * for some reason the nz function does not work in this case. I hope that helped you I will be able to give you a better answer if you give me more details... Let me know what happend Good luck Daniel

Posted on Sep 06, 2007

## 1 Suggested Answer

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

×

my-video-file.mp4

Complete. Click "Add" to insert your video.

×

## Related Questions:

### What is the difference between auxiliary, action, and linking verbs?

hi amanda.
What is the difference between auxiliary and linking verbs? Remember that every sentence must have both a subject and a verb to be complete. Alinking verb is quite different from an action verb in that it doesn't actually express action. ... An auxiliary verb, also referred to as a helping verb, is one that is the part of a verb phrase that helps the main verb.

### Action, Linking and Auxiliary Verbs: Definitions, Functions & Examples ...

study.com/.../action-linking-and-auxiliary-verbs-definitions-functions-examples.html Search for: What is the difference between auxiliary and linking verbs?

What is the difference between auxiliary action and linking verbs Google...

Nov 10, 2017 | The Computers & Internet

### List of all linking verbs

Here is a list. Does it contain them all? I wouldn't know. Is the list printable? That is your problem.
You can ignore the definition at the beginning. You can ignore the reference (at the end).

Linking verb = copula. The most common is be
Here is a definition
A verb has copular complementation when it is followed by a subject complement or a predication adjunct and when this element cannot be dropped without changing the meaning of the verb.
Copular verbs fall into two main classes, according to whether the subject complement has the role of current attribute or resulting attribute.
The most common copular verbs are listed below
Current: appear, be, feel, look, seem, smell, sound, taste.
Resulting : become, get, go, grow, prove, turn.

From S. Greenbaum and R. Quirk, A Student's Grammar of the English Language, Addison Wesley Longman Limited, Edinburgh gate, Harlow, Essesx 1990, Reprinted 1996

Dec 04, 2013 | Computers & Internet

### Linking verbs examples and definitions

Linking verb = copula. The most common is be
Here is a definition
A verb has copular complementation when it is followed by a subject complement or a predication adjunct and when this element cannot be dropped without changing the meaning of the verb.
Copular verbs fall into two main classes, according to whether the subject complement has the role of current attribute or resulting attribute.
The most common copular verbs are listed below
Current: appear, be, feel, look, seem, smell, sound, taste.
Resulting : become, get, go, grow, prove, turn.

From S. Greenbaum and R. Quirk, A Student's Grammar of the English Language, Addison Wesley Longman Limited, Edinburgh gate, Harlow, Essesx 1990, Reprinted 1996

Nov 04, 2013 | Games

### Installed my Compaq Visual Fortran Professional Edition Version 6.5 on my laptop PC with Windows Vista - tried to create executables for my existing Fortran files (on Windows XP everything works...

be like the first FORTAN, post ever in 25 years, wow, what a BLAST FROM THE PAST !
ID say you are missing some FORTARN LIBRARY"s

join a Fortran form? with old retired guys, there. form prime time circa 1970? or older?
this is a very old math based (formula) complied language.
It is a very limited and near useless Language. (used by bankers)
its totally obsolete now, finding all the pieces to make it work can be hard. for sure old long gone now, Libraries.
at link time those are RESOLVED.
yours fails there, it can find them.

id read the source and find those eternal links.
then see if the poor old sod put comments there.
like (this is advanced Trig functions in lib, xxxxx , sold by zzzzz0
it can be anything, the purpose of the program was not stated.

May 12, 2017 | Compaq Visual Fortran Professional Edition...

### Module not found in Access 2003

Is it used as a subform in another form? Also does it have any events which are referenced by other forms?

Jul 08, 2009 | Microsoft Computers & Internet

### Want to populate a form with data from a table, the Id number is keyed into the form and once it's matches with the Id in the table I want the other fields on the form to be populated with the data from...

Create a Form from the main table with a subform based on the other data you will want populated. You put the fields in the subform that you want populated from the main form. Go to the properties for the subform and select the data tab, In the data tab, select the Link Master Fields and choose the field you want linked. When you type the ID number in the main form, the other firlds you have in hte subform should populate from the data inthe table.

May 14, 2009 | Microsoft Access 2003 for PC

### How to compare a value in a subform with parent form's value in Dcount

Assuming that Process id is an integer, this should do the trick:

DCount("[stageid]", "Process Stages", "[Process id] = " & Me.Parent! [Process id])

Regards -- Joe (Access VBA samples)

May 01, 2008 | Microsoft Office Access 2003 (077-02871)...

### Access 2003 HELP PLEASE!

Sharon King:

Did you get this problem solved? I realize it is quite old, but I am willing to help if it is not solved. If it is, I would be interested to know what happened...

smartsolve

Feb 18, 2008 | Microsoft Office Access 2003 (077-02871)...

### View Reports

Hi, There a couple of different way you could do this and I have put two lots of VB code below that you can modify and use. Firstly you create the Combobox list by choosing the option that you will type the values yourself, you then type in all your report names on each line. After that you can then go to the VB code editor and paste my code in and modify it by changing my report names, (Customers) etc to your report names. Make sure you choose the Combobox and the On_Click option in the VB editor to paste the code into.  I like the first method better which checks the value of the Combobox and then opens the corrosponding report in the maximised form. The second method does the value check before running an assigned macro to open each report. With this you must first assign macros to each report in Access.  Remember each of these bits of code must be placed between the "Private Sub" heading and the "End Sub" ending, and change the "Combo23" name to reflect your combobox too. If you need a hand just email me.

First Method

If Combo23.Value = "Customers" Then
DoCmd.OpenReport "Customers", acViewPreview, acWindowNormal
DoCmd.Maximize

ElseIf Combo23.Value = "Customers 1" Then
DoCmd.OpenReport "Customers1", acViewPreview, acWindowNormal
DoCmd.Maximize

ElseIf Combo23.Value = "Customers 2" Then
DoCmd.OpenReport "Customers2", acViewPreview, acWindowNormal
DoCmd.Maximize

End If

Second Method

If Combo23.Value = "Customers" Then
DoCmd.RunMacro "Macro1"
DoCmd.Maximize
ElseIf Combo23.Value = "Customers 1" Then
DoCmd.RunMacro "Macro2"
DoCmd.Maximize
ElseIf Combo23.Value = "Customers 2" Then
DoCmd.RunMacro "Macro3"
DoCmd.Maximize
End If

Oct 28, 2007 | Computers & Internet

### Restict closing the main form when some controls on the subform are empty

Hi there. I didn't notice this was so old until I had already worked on it for some time. Did you get this the way you want it? If not, I suggest either using a BeforeUpdate control to ensure the condition is met that the subform contain data, or validate the particular field(s) with isnull. Thanks for posting back if you still need help, or otherwise rating FixYa!

Oct 03, 2007 | Microsoft Office Standard for PC

## Open Questions:

#### Related Topics:

105 people viewed this question

## Ask a Question

Usually answered in minutes!

Level 3 Expert

Level 3 Expert