displaying a grand total value in the masterform.

P

Paulc

Hi,

I have a MasterFrm with 2 embedded SubFrms; MasteFrm>SubFrm1>SubFrm2
SubFrm2 contains a value in Table1

When a user selects a category in the MasterFrm, the 2 SubFrms are populated
accordingly.

I would like to sum total only those values where the selected category and
category in Table1 match.

I'd like the sum value to then display in the MasterFrm.

Any ideas appreciated,
Thanks, Paul
 
Top