I have a form which is in a tab layout form. (6 separate but related subforms) On one of the subforms, I have listed various item totals, which are then summarized with a grand total in the form footer. On another subform within the same, I would like to be able to bring this total over to be summarized within another grand total. My expression in my textbox in my final subform which I want to capture this total is as follows:
=[Forms]![Main Form]![Subform Name]![Subform Field Name]
translated into:
Main Form = Main Tab Form, "ConcernLog"
Subform = subform within a tab page "ConcernParts"
Subform Field Name = page footer "Total"
I keep getting the Name# error. I realize that Access 2000 is very strict about using the full path for these type of expressions, whereas in Access 2.0 and 97 it allowed you some leeway.
Any help would be appreciated, as it would save from entering this total manually.
Thanks.
=[Forms]![Main Form]![Subform Name]![Subform Field Name]
translated into:
Main Form = Main Tab Form, "ConcernLog"
Subform = subform within a tab page "ConcernParts"
Subform Field Name = page footer "Total"
I keep getting the Name# error. I realize that Access 2000 is very strict about using the full path for these type of expressions, whereas in Access 2.0 and 97 it allowed you some leeway.
Any help would be appreciated, as it would save from entering this total manually.
Thanks.