using a chkbox to add totals 1

[kpryan]

Hi all,
I have a continuous form where a field (AmmtRcvd) is the amount received. I also have a chkbox which when checked shows that the amount has been received.
I would like to when the chkbox is checked to add up all the Amounts received.

Ken

 

[TheAceMan1]

How are ya kpryan . . .

Have you tried DSum?

[blue]=DSum("[AmmtRcvd]","TableName","[CheckboxName] = True")[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[kpryan]

Hi TheAceman1,
I do really appreciate all the help you have given to me. being a novice and still learning, its guys like you that teach us thing you don't learn at Uni.
With this code that you gave me, I am not able to get it to work.

But perhaps I did not explain myself clearly.
I have a text box which when the check box is checked then the ammountRcvd would be totaled in that text box
So in your code(=DSum("[AmmtRcvd]","TableName","[CheckboxName] = True")) where would I put this code, on the text box? Would it be in the control source of the text box, or in the condtional formating or would it be in the vba code of the checkbox?


Many Thanks,

Ken

 

[TheAceMan1]

kpryan . . .

Control Source! . . .

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[kpryan]

Hi TheAceman1,

I did as you suggested, and out the code in the Control Source.
When the form is opened the text box (Currency) actually shows the total amount that is O/S. So when the checkbox is checked nothing happens.

Ant ideas what I am doing wrong

Ken

 

[kpryan]

Hi theAceman1,
Solved the problem works ok now

Thanks,

Ken