Totals on a Continuous Form

  • Thread starter Thread starter Joe Harman
  • Start date Start date
J

Joe Harman

I have a Continuous Form with 6 numeric fields (along
with some descriptive fields, of course) in the detail
section. The numeric fields are lined up across the form
next to each other, i.e, they all have a Top property of
0. They each have a width propery of .5" and the Left
property of each is .5" larger than the Left property of
the text box on the left.

In the Footer of this Continuous Form, I have 6 text
boxes directly below the 6 numeric fields in which I have
placed the function =([fldname]). fldname is the name of
the corresponding control on the detail section of the
form. fldname is also the field name of the
corresponding Source query for the form.

In design view, if I view the Properties and select the
text boxes on the Footer one at a time, the only thing
that changes is the Name and Tab Index of the Other
Properties; the fldname in the function in the
ControlSource Property of the Data Properties; and the
Left property in the Format Properties. There is no
module and therefore no Events.

The detailed explanation, above, was to convince you that
I've checked it out pretty carefully.

THE PROBLEM: When I open the form, the totals in the
first three text boxes on the Footer are correct but the
other three show the same amount as the first record.
This happens when the form is unfiltered and when it is
filtered. I filtered it many ways and the result is
consistent. The first three text boxes on the Footer are
correct but the other three aren't.

Has anyone else run into this problem? Any ideas?
 
I have 6 text
boxes directly below the 6 numeric fields in which I have
placed the function =([fldname]).
Click to expand...

This will, of course, not *sum* anything.

If you want a Sum, tell the poor program what you want: use a Control
source of

=Sum([fldname])
 
Back
Top