Recalculate Total

[Gustavo]

Hi Everyone,
I have a form in Access 97 that shows an amount (source
field) in every record and next to it I have the same
amount where the user using a percent factor changes the
original amount (calculated field), also next to these
two controls I have a "Yes/No" type of field (source
field) for the user to select or deselect that record.
The problem is that when the user changes the percent or
selects the record the total does not recalculate
immediately, I have to close the form and re-open it. Can
anybody help me to solve this problem?

Thanks in advance
Gustavo

 

[tina]

-----Original Message-----
Hi Everyone,
I have a form in Access 97 that shows an amount (source
field) in every record and next to it I have the same
amount where the user using a percent factor changes the
original amount (calculated field), also next to these
two controls I have a "Yes/No" type of field (source
field) for the user to select or deselect that record.
The problem is that when the user changes the percent or
selects the record the total does not recalculate
immediately, I have to close the form and re-open it. Can
anybody help me to solve this problem?

Thanks in advance
Gustavo
.

 

[tina]

-----Original Message-----
Hi Everyone,
I have a form in Access 97 that shows an amount (source
field) in every record and next to it I have the same
amount where the user using a percent factor changes the
original amount (calculated field), also next to these
two controls I have a "Yes/No" type of field (source
field) for the user to select or deselect that record.
The problem is that when the user changes the percent or
selects the record the total does not recalculate
immediately, I have to close the form and re-open it. Can
anybody help me to solve this problem?

Thanks in advance
Gustavo
.
you could try requerying the calculated control, in the

form's OnCurrent event and/or in the data entry control's
AfterUpdate event, as
Me!CalculatedControlName.Requery