• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 515
  • 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

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

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