Totals from Subform to Main form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've read all of the other relevant posts, but this just isn't clicking.
Here's what I have:

A form called Investigations (main form)
A subform called Compromised_Products_History with a column named
"Compromised_Value".

I'm trying to get a calculation of the Compromised Values to show up on my
main form.

I also have a textbox calculation (called SumOfValues) that does work on the
subform that gives me the total I'm looking for. This is the Control Source
for a textbox on the main form as it stands:

=Compromised_Products_History.Form!SumOfValues

I'm always getting #Name?

I'm leaving it just like that and going home now. Any weekend help would be
greatly appreciated!
 
Scott said:
I've read all of the other relevant posts, but this just isn't clicking.
Here's what I have:

A form called Investigations (main form)
A subform called Compromised_Products_History with a column named
"Compromised_Value".

I'm trying to get a calculation of the Compromised Values to show up on my
main form.

I also have a textbox calculation (called SumOfValues) that does work on the
subform that gives me the total I'm looking for. This is the Control Source
for a textbox on the main form as it stands:

=Compromised_Products_History.Form!SumOfValues

I'm always getting #Name?
Click to expand...


Double check the Name of the subform ***control*** on the
main form. It may be different from the name of the form
object (SourceObject) it is displaying.
 
=Forms!Investigations!Compromised_Products_History.Form!SumOfValues

Make sure the name of the subform CONTROL is "Compromised_Products_History"
as you could have a form called "Compromised_Products_History" but give the
subform control the name "Fred".

Regards John
 
Back
Top