RePost: Calculations not clearing when new record added

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

Deb

I previously posted a problem with a subform's field
calculations not reseting to zero when user goes to new
record. Ron Robertson was kind enough to give me the
following response:

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

Being a newby, I didn't give enough information in
original post - I apologize.
There are 10 text boxes containing calculations on the
subform - each a total of approx 5 fields which are
populated by the user on the current subform.
How would one perform all the calculations in the
OnCurrent event?

All help is truly appreciated. You guys are great!!!
 
I previously posted a problem with a subform's field
calculations not reseting to zero when user goes to new
record. Ron Robertson was kind enough to give me the
following response:

In the OnCurrent event of the main form, perform the
calculation or set

Being a newby, I didn't give enough information in
original post - I apologize.
There are 10 text boxes containing calculations on the
subform - each a total of approx 5 fields which are
populated by the user on the current subform.
How would one perform all the calculations in the
OnCurrent event?

All help is truly appreciated. You guys are great!!!
Click to expand...
-------------
Hi Deb,

You just assign zero to each and every one of the 10 textboxes in the
OnCurrent event, for example:

Me!Textbox1 = 0
Me!Textbox2 = 0
...
Me!Textbox10 = 0

Hope this helps,
 
Back
Top