Subform display details but main form calc & display totals 1

[victory92]

I want to use subforms to display detail and display the total of one of the subform fields in the main form.

Specifically I show detail information of exclusion code and exclusion amount in the subform. I want to total the exclusion amount and display it on the main form.

Is there anyone that can show me the code or technique to do this.

Thanks!!

 

[KenReay]

Hi

On the SUb Form, put a control (maybe in the form footer) say txtTotal set its source to =sum(ExclusionAmount) and set its visible property to false

On the Mainform put a control and set its source to = MySubFormControl.FORM.txtTotal

you need to use your control names of course

Hope this helps Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK

 

[victory92]

Thanks Ken. This worked perfectly!!