Solved

dsum depend on checkbox

Posted on 2013-06-20
2
487 Views
Last Modified: 2013-06-20
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
Comment
Question by:drtopserv
  • 2
2 Comments
 

Accepted Solution

by:
drtopserv earned 0 total points
Comment Utility
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
 

Author Closing Comment

by:drtopserv
Comment Utility
:}
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

This article is meant to give a basic understanding of how to use R Sweave as a way to merge LaTeX and R code seamlessly into one presentable document.
This article will show, step by step, how to integrate R code into a R Sweave document
An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now