Access 97 Subform Calculation on Main Form

[shankbanta]

Received help previously and now have another issue.

I have a subform that creates a calculation that is embedded in a main form. In the control source of the main form I have =[Query].[Form]![Total Sections]
This places the calculation from the subform into the field Sections of the main form. If the above code is in the control source, how do I get the result of the calculation to write to the field [section] in the table?

More Detail:

BTD Table has a 1 to many relationship with the Form Table.
The Subform [Forms] calculates the field [total sections] from a query based on the Forms table. The subform is embedded in the main form. The MainForm [EntryForm] has a field called [Sections] that needs the [total sections] calculation from the subform that is used in many reports.

Hope this is clear information

 

[Darrylles]

Hi,

In which table is the field [SECTION}?

Regards,

Darrylle

"Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk

 

[shankbanta]

Section in the the BTD table. The Total Sections is in the Forms table.


I kept the calulcations to be performed in the query and not in the table.