Calculations not clearing when new record added

[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!!

 

[Ronald W. Roberts]

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!!

In the OnCurrent event of the main form, perform the calculation or set
the totals
to zero.

Ron

 

[Deb]

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?