Calculations not clearing when new record added

  • Thread starter Thread starter Deb
  • Start date Start date
D

Deb

Using Access 2000. Have a form with a subform where
totals are calculated. When user selects go to new record
command button, the calculations from the first form do
not reset to zero - the totals are added into the new
record.

This newby needs very simple directions. All help is
greatly appreciated!!
 
Deb said:
Using Access 2000. Have a form with a subform where
totals are calculated. When user selects go to new record
command button, the calculations from the first form do
not reset to zero - the totals are added into the new
record.

This newby needs very simple directions. All help is
greatly appreciated!!
Click to expand...
In the OnCurrent event of the main form, perform the calculation or set
the totals
to zero.

Ron
 
Ron, thank you for your reply. There are 10 separate
calculations on the subform. How would you perform the
calculations in the OnCurrent event? Is there code that
needs to be written?
 
Back
Top