Calculating Field

[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

 

[Kevin Sprinkel]

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

 

[DBarker]

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
.

.

 

[DBarker]

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

added

a
.

.