Creating a Total Field in a Form that contains a Subform

[mvillara]

Well, I have two forms called: "Products List" and "Offers". They are related to each other by the field IDOffer. So, the "Offers" form have "Products List" as a subform. This means that for each offer I create, I have many Products that are selected in the subform placed in the main form: "Offers". Well, now I want to put a field in the main form that calculate the sum of all the products chosen in the subform. It has been imposible for me to get this by now.

Could someone HELP me giving me an advise?

Thanks in advance.

 

[KenReay]

Hi

On the sub form (offers) in the footer section, create a text box control (txtTotal), with control source =Sum(MyfieldValue), set its visible property to false

On the main form, create a text box control, set its control source = [SubFormControl].Form!txtTotal
Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK

 

[KenReay]

Hi

In the footer of the sub form create a control (textbox), set its visible poperty to false, and its control source to =Sum(MyField).

On the main form create a text box control. Set its control source to = Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK

 

[mvillara]

Ken Reay, thanks for your answer.

I have done it as you expline in your answer but the result is: "#Name?"

In the "Offers" form I show many Products form "Products List", so, How the program know how many records from "products List" should sum?

 

[mvillara]

KenReay, ok..... ALl is OK!!!!!!

PERFECT!!!! I made a mistake but now all is all right.

Many thanks.