help with running balance based on checkbox

[Brook]

good day all,

I have frmchecking account that I use for my accounting and within the
checking account form I have a checkbox "reconciled" that I want to use when
my bank statement arrives.

I would like to have a control(s) on my form so that when I clikc the
reconciled checkbox, a total is created with this control that would
"cooresponsd " with the balance on my statement.

Does anyone have any tips suggsetions? ideas?

Thanks,

Brook

 

[Klatuu]

You can use the check box's After Update event for that. You will also need
to allow for someone unchecking a box.

If Me.chkReconciled = True Then
Me.txtBalance = Me.txtBalance + Me.txtChkAmt
Else
Me.txtBalance = Me.txtBalance - Me.txtChkAmt
End If

 

[Brook]

Thank you,

Would I need the txtbalance for each record? or just as a control on the
form footer?

Brook

 

[Klatuu]

I guess you could do it either way. The way I wrote it would only give you
one total balance. If you wanted a balance for each record, you would have
to change the code a little.

 

[Brook]

Thanks Klatuu,

That worked perfectly...

Brook

I guess you could do it either way. The way I wrote it would only give you
one total balance. If you wanted a balance for each record, you would have
to change the code a little.

 

[Brook]

Hello,

I have one more question for you... IF I start my reconcilation and close
my form, my txtbalance returns to Zeror and none of my "checkboxs" remain in
the calculation of the new txtbalance.

Is this clear?

any suggestions?


Thanks,

Brook