Linking Calculated Totals from subforms to the main form.

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...

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

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

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.

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

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.

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)

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

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

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!