Different type of problem

[Afrosheen via AccessMonster.com]

Thanks for reading this.

I have a form with 3 fields. Earned, Used, and Bal. I've got the calculations
so it shows the correct balance in the Bal field if something is Earned or
Used.

When you enter anything in the Earned field a new record line shows up just
below. What I'd like to do is after I've completed entering information in
the fields, I'd like the balance from the Bal field to be brought down to the
Earned field. Like being able to keep a running total/balance in the Bal
field.

Can this be done? I'm not sure how to do this or if it could be done.

 

[Tom van Stiphout]

On Thu, 11 Feb 2010 11:57:49 GMT, "Afrosheen via AccessMonster.com"

Perhaps this would work:
In the Form_AfterUpdate write:
Me.Earned.DefaultValue = Me.Bal

-Tom.
Microsoft Access MVP

 

[Afrosheen via AccessMonster.com]

Thanks for getting back to me. It will work.

What it does is when the new line pops up then it will show the previous
earned in the new record. This is ok, because when it updates on the form
then the correct balance from the bal field is inserted in the earned field.

I put it in the Form_AfterUpdate not the Bal_AfterUpdate

Thanks again Tom. I appreciate the help.

Perhaps this would work:
In the Form_AfterUpdate write:
Me.Earned.DefaultValue = Me.Bal

-Tom.
Microsoft Access MVP

Thanks for reading this.

[quoted text clipped - 9 lines]

Can this be done? I'm not sure how to do this or if it could be done.