Sum operation into a Form linked with Subform

[charly.csh]

Hello everyone,



I have a question.

How to perform a sum operation into a form linked with a subform?

I have into a form named Main_form a textbox field named "Me.Code_Id" and also into this form a subform named "Subform1".

Into Subform1 there is a textbox field named "Code" and a second one named "Price"

Both forms are linked with the fields "Me.Code_Id" as Master and Code as Child



Into the form named "Main_Form" there is a field named "Total" and what I want to do is that in total will be shown the sum of the prices of each record from "Subform1" where Code = Me.Code_Id

Can somebody help me with the sequence that should be introduced into the field?


Thanks so much for the support!!!

[June7]

Is the subform in datasheet or continuous view?

One approach:

Create a textbox in subform footer that has expression: =Sum([Price])

Another textbox in main form can reference the subform textbox: = [subformcontainer name].Form.textboxname

[charly.csh]

Hi!

This is in continuous view.

I had some issues with the textbox into the main form, I added the textbox but I had some issues with the sequence


Me.Totaltxt =[Forms].[Main_Form].[Subform1].[Price]

How should be it fixed?

Thanks for the support!!!

[June7]

Per my example.

Subform textbox: =Sum([Price])

Main form textbox: =[Subform1].Form.[textbox name]