I need my form to get the value of Balance field when I start a new record entry

[hjnash]

I finally got the database started and in part date entry is working. I am stuck however with a simple
aspect of the money management process. The database has 4 currency fields; they are,
Opening_Deposit, Deposit, Spending, and balance. When I enter a record say Opening_Balance 300.00 the
code will add balance to Opening_Deposit and enter the total in Balance, this works. Now I hit page down
in the form to get a new record. This must show the balance from the last record. I can not figure the logic
to get started. Even if I figure that out I may not figure out the code structure. SO anyone what to point me


in the direction I need to go?

[Missinglinq]

There are a couple of ways to do this, but you can use the AfterUpdate event of the Control holding your data to set the DefaultValue for the Field. From that time forward, until you either manually change the data or close your form, the data will be entered automatically in each New Record.

To be honest, I'm a little confused as to what you're trying to do with what, here, but in the code below, you need to replace

Opening_Balance

with the actual name of the Control that you want to be automatically populated, when you create a New Record.

You then need to replace

Balance

with the actual name of your Control that holds the data that you want to carry forward to the New Record

Private Sub Form_BeforeUpdate(Cancel As Integer)
   Me.Opening_Balance.DefaultValue = """" & Me.Balance.Value & """"
End Sub

Linq ;0)>

[hjnash]

Thank you I will see If I can make this work, Still looking this stuff up on the internet.

[hjnash]

I was not able to get this to work, in my form how do I add a new control? Do I need to have a matching field in the table for the control?
I spent the last week reading my new book but it does not cover this topic, so I have been reading posts in this forum but do not see what
I am looking for can you provide a little more info please.

Thanks Harry Nash!

[pbaldy]

It would be a big violation of normalization rules to store the balances. Just store the transactions and calculate balances on form/reports. What happens when you edit a transaction? All later records are then wrong. You should also have a date/time field so you can order the records.

[hjnash]

I have removed fields in the table for now to make the money balance Challenge uncluttered in the reports, I will
add date and other fields back in once I get the balance working. I just am not able to figure out how to get the
balance and even if I figure that out, how then do I display this balance. I am sure I need to have an event that
will fire off when I open the data entry form, perhaps even the query should have the total. So I need help with!
what is the best event trigger to use.
what code do I write to get the balance.
how do I display the balance.

Thanks Harry Nash!

[pbaldy]

I think you need the date field now, or some field that enables you to sort the records. If you search on running sum or balance you should get several methods. You can do it in a query with DSum() or a subquery, in a report with the running sum property of a textbox, etc. It can be done with code, but it's probably not necessary.