creating a checking acct form... create balance based on checkbox?

[Brook]

good day all,

I have a frmchecking that I use for my checking account registry. I have
a checkbox called "Reconciled" and is defaulted to false. I have a field
Debit_Credit and Balance. What I would like to do is when the Recociled check
box is clicked, the field Balance is updated with the new balance based on
Debit_Credit.

How would I go about doing this?

Thanks,

Brook

 

[Dennis]

In the after update event of the Reconciled checkbox put the following code

[Balance] = [Balance] - [Debit_Credit]

 

[Brook]

Thanks for the reponse,

I tried that and got update in my field (Balance). For the afterupdate
event, do I need to have : Me.Balance = Me.Balance - Me.Debit_Credit?

Or just exactly how you had it? Does the field Balance need to be unbound?

Brook

In the after update event of the Reconciled checkbox put the following code

[Balance] = [Balance] - [Debit_Credit]

good day all,

I have a frmchecking that I use for my checking account registry. I have
a checkbox called "Reconciled" and is defaulted to false. I have a field
Debit_Credit and Balance. What I would like to do is when the Recociled check
box is clicked, the field Balance is updated with the new balance based on
Debit_Credit.

How would I go about doing this?

Thanks,

Brook

 

[Dennis]

It will work with or without the Me.
Bound or Unbound depends on your DB structure.
How is the initial balance obtained before the calculation ?
You should not normally store calculations in tables.

Thanks for the reponse,

I tried that and got update in my field (Balance). For the afterupdate
event, do I need to have : Me.Balance = Me.Balance - Me.Debit_Credit?

Or just exactly how you had it? Does the field Balance need to be unbound?

Brook

In the after update event of the Reconciled checkbox put the following code

[Balance] = [Balance] - [Debit_Credit]

good day all,

I have a frmchecking that I use for my checking account registry. I have
a checkbox called "Reconciled" and is defaulted to false. I have a field
Debit_Credit and Balance. What I would like to do is when the Recociled check
box is clicked, the field Balance is updated with the new balance based on
Debit_Credit.

How would I go about doing this?

Thanks,

Brook

 

[Brook]

So, should I setup an unbound text box, format currency, default value to
$0.00?

Brook

It will work with or without the Me.
Bound or Unbound depends on your DB structure.
How is the initial balance obtained before the calculation ?
You should not normally store calculations in tables.

Thanks for the reponse,

I tried that and got update in my field (Balance). For the afterupdate
event, do I need to have : Me.Balance = Me.Balance - Me.Debit_Credit?

Or just exactly how you had it? Does the field Balance need to be unbound?

Brook

In the after update event of the Reconciled checkbox put the following code

[Balance] = [Balance] - [Debit_Credit]

:

good day all,

I have a frmchecking that I use for my checking account registry. I have
a checkbox called "Reconciled" and is defaulted to false. I have a field
Debit_Credit and Balance. What I would like to do is when the Recociled check
box is clicked, the field Balance is updated with the new balance based on
Debit_Credit.

How would I go about doing this?

Thanks,

Brook

 

[Brook]

Thank you...

I was able to get it working, however, when I click my update check box,
is it possible to "maintain" my previuos balance? I guess, similar to a
running balance?

Brook

It will work with or without the Me.
Bound or Unbound depends on your DB structure.
How is the initial balance obtained before the calculation ?
You should not normally store calculations in tables.

Thanks for the reponse,

I tried that and got update in my field (Balance). For the afterupdate
event, do I need to have : Me.Balance = Me.Balance - Me.Debit_Credit?

Or just exactly how you had it? Does the field Balance need to be unbound?

Brook

In the after update event of the Reconciled checkbox put the following code

[Balance] = [Balance] - [Debit_Credit]

:

good day all,

I have a frmchecking that I use for my checking account registry. I have
a checkbox called "Reconciled" and is defaulted to false. I have a field
Debit_Credit and Balance. What I would like to do is when the Recociled check
box is clicked, the field Balance is updated with the new balance based on
Debit_Credit.

How would I go about doing this?

Thanks,

Brook