I have a form that contains 4 subforms. 2 of the subforms calculates a total
on the main form. One of those totals is displayed on the main form no matter
the subform I'm on and I have done all I can think of to stop it without
luck. Any help greatly appreciated.
Sounds to me like you have these subforms on a Tab Control, and you're seeing
this subform no matter which tab page is selected. If that's the case, the
problem is that the subform is actually "in front of" the Tab Control, not on
one of the tab pages.
If that's the case, open the form in design view. Select the subform (click
its edge so that you see the black "handles" on the four corners and four
sides). Type ctrl-X to cut it to the clipboard. Select the tab page on which
you want the subform, by clicking the tab - NOT the surface of the page, but
the little rectangular tab with the label; the page should darken indicating
that it's been selected. Type Ctrl-V to paste the subform from the clipboard;
move it where you want it. Save the form and see if it's behaving better.
