RePost: Calculations not clearing when new record added

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.

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

Eric Cardenas

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top