Calculating Field

  • Thread starter Thread starter DBarker
  • Start date Start date
D

DBarker

I have a subform with an amount field, and I have added a
field to the subform to calculate the total of multiple
entries and I have that amount checked against the total
amount entered in the header. I have fixed the tab order
and for some reason that field is not updating when
tabbing through. This is effecting the validation
process and can not move any further.

Thanks,
Debbie
 
What is the control source of the calculated control?
Something like:

= [fld1]+[fld2]+[fld3] ?

This will recalculate automatically if any of the the
fields involved in the calculation change.

HTH
Kevin Sprinkel
 
It is a subform that contains a field Amount. For any
one ID there can be multiple entries of the subform and
the field amount. I want to calculate the totals of the
amounts entered and compare that with the total amount
entered by the user.

I have tried to post this several times and have not been
successful.

Debbie
-----Original Message-----
What is the control source of the calculated control?
Something like:

= [fld1]+[fld2]+[fld3] ?

This will recalculate automatically if any of the the
fields involved in the calculation change.

HTH
Kevin Sprinkel
-----Original Message-----
I have a subform with an amount field, and I have added a
field to the subform to calculate the total of multiple
entries and I have that amount checked against the total
amount entered in the header. I have fixed the tab order
and for some reason that field is not updating when
tabbing through. This is effecting the validation
process and can not move any further.

Thanks,
Debbie
.
Click to expand...
.
Click to expand...
 
Never Mind I figured this out.

-----Original Message-----
It is a subform that contains a field Amount. For any
one ID there can be multiple entries of the subform and
the field amount. I want to calculate the totals of the
amounts entered and compare that with the total amount
entered by the user.

I have tried to post this several times and have not been
successful.

Debbie
-----Original Message-----
What is the control source of the calculated control?
Something like:

= [fld1]+[fld2]+[fld3] ?

This will recalculate automatically if any of the the
fields involved in the calculation change.

HTH
Kevin Sprinkel
-----Original Message-----
I have a subform with an amount field, and I have
Click to expand...
Click to expand...
added
a
.
Click to expand...
.
Click to expand...
 
Back
Top