dsum depend on checkbox

attached sample.
i need to have txtsum value depend of checkbox (true.false)
means sum all checkbox only when true. (before update)
samplev4.accdb
drtopservAsked:
Who is Participating?
 
drtopservAuthor Commented:
Well,thnx i have found the solution,
i should use checkbox afterupdate :
If Me.Dirty Then Me.Dirty = False
and use :
=Sum(IIf([chkbox]=True,[amount],0))
in the source control of the txtsum
0
 
drtopservAuthor Commented:
:}
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.