I was wondering how to use a sum that is calculated on a subform on another subform. I have no trouble getting the value to the parent form. However, I cannot get another subform to see this number. It just shows a blank textbox. Is there any way that I can get this calculated sum on another subreport, or would I have to include the data into the subform's Record Source? Hopefully there is another way, because that would cause some complications.
Using a subform sum on another subform
- Thread starter Norstar2
- Start date
If you can get the value to the parent from the subform, then can you also get it from the parent to the subform? Because if you can you can make a text field in the parent form, save that data on the in the parent form. Then transfer that to the other subform. Then, since this text field is not really needed, you can set the visible to false. This is just a suggestion, kind of a cheap way I guess 
