How to reset values to zero at form opening in MS Access 2000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, I'm using Access 2000. I have a form that contains a calculated
control; a total which has summed the 8 entries entered for that record.
That function is working correctly. I then want to open a new form for the
next record with all values reset to zero. However, the calculated controls
answer from record #1 is being carried forward, being used as part of the
calculation for the answer for record #2. I want each form to be independant
with no results carried forward. The record results do remain independant in
a table/query. Thanks for any help.
 
When did you activeted the calculation?
If you used the after update event of each field that participate in the
calculation, then you can do two things
1. Move that code to the Oncurrent event of the form
2. I would write the calculation in the control source of the field, that
way it will update automatically
=[Field1]+[Field2]+[Field3]
 
Back
Top