Running a total or balance in VB

[ChymeIndy]

Probably not phrased correctly, but heres the prob...I've designed a vb form to use with a database (MSAccess). Using dataenvironment to connect the database. I need to allow the user to add (or subtract) money to their balance, then calculate a current balance based on the input. Any advise?

[JHausmann]

The question is are you planning on keeping all the various transactions or is the current balance all you ever need ?

I'd design the database to have two tables, one that contains the Total amount and the other all the transactions to the account. After you write a record to the transaction table, you update the total table with the appropriate amount.

[ChymeIndy]

Thanks for the response. The design is with two tables as suggested, but the problem is that it doesn't record the transactions when I test it. It will calculate based on whether I select credit or debit, but when I look over in the database nothing's there.

[JHausmann]

Is the total being written or is _nothing_ being written?

Can you post the code you're having problems with?

[ChymeIndy]

Here's the code, I'm not sure if this is where my problem is though...

Private Sub txtTransactAmt_Change()
Dim Msg, Response
Dim Recordset
Dim I As Integer

If optDebit.Value = True Then
txtBalAfterTrans = CCur(CDbl(lblCurrentBalance) - CDbl(txtTransactAmt))
Else
If optCredit.Value = True Then
txtBalAfterTrans = CCur(CDbl(lblCurrentBalance) + CDbl(txtTransactAmt))
End If
End If
End Sub

[JHausmann]

What access method are you using, DAO or ADO? I'd expect to see a recordset update...