add new record from previous

[DeepBlerg]

Hi,

what I need to do is be able to add a new record to the mdb depending on what is in the previous record.

so for eg:

first record: balance=$0
previous record: add $40 balance=$40
new record: add $10 balance=$50

this is the code I have attached to an OK button:

rsRecordSet.Source = "Select * From log_deposit"
rsRecordSet.ActiveConnection = connConnection
rsRecordSet.Open
rsRecordSet.AddNew
rsRecordSet("Period&quot.Value = txtperiod.Text
rsRecordSet("Date&quot.Value = txtdate.Text
rsRecordSet("Balance&quot.Value = rsRecordSet("Balance&quot + txtamount.Text
rsRecordSet.Update

So if anyone knows how to do this, pls reply

Thanks.

 

[petermeachem]

I would be tempted to either keep the running total in another table (as a single figure), or calculate it when you need it. Doing it your way would be a bit of a pain if you altered a value halfway down the chain wouldn't it. Peter Meachem
peter@accuflight.com