Issue to split subform on the main form

Chowdary

Hi,

I have Main form and Subform. Subform has filed of Type with two options. I got to show Subform with Type 1 as one subform and Type 2 as another subform on the main form. I have successfully done till here. I have also got to show totals for Type 1 on 1st subform and Type 2 on 2nd subform. As two subfoms are one totals are shoing same on both the forms.

Any ideas would be highly appreciated!

Thank You
Chowdary

einsTeIn.NET

I would create a subform that includes the totals for all shown lines. If the subform is filtered to Option Type 1 then it would also show the total for Option Type 1, if the subform is filtered to Option Type 2 then it would also show the total for Option Type 2.