Recalculate Total

  • Thread starter Thread starter Gustavo
  • Start date Start date
G

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
 
-----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
.
Click to expand...
 
-----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
Click to expand...
form's OnCurrent event and/or in the data entry control's
AfterUpdate event, as
Me!CalculatedControlName.Requery
 
Back
Top