Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 508
  • Last Modified:

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
0
drtopserv
Asked:
drtopserv
  • 2
1 Solution
 
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

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now