 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / September 2005Sum a tabular subform
Hi all, I have a sub form that contain an amount field. I have a Total amount field on a form that the subform is bound to. I'm trying to add to the Total field each entrance of the amount field but with no luck. only the LostFocus seems to do the trick but i don't think that the user will even enter the amount field(the amount field is calculated). Any suggestions? Thanks in advance On the after update event of the amount field, you can write the code Me.Refresh That way the sum field will update after you enter the new amount and not after you exit the record  SignatureI hope that helped Good luck > Hi all, > I have a sub form that contain an amount field. [quoted text clipped - 4 lines] > Any suggestions? > Thanks in advance Hi Ofer and thanks for the reply. The problem is that the procedure doesn't trigger the AfterUpdate event at all. I've tried to write the sub there but nothing happened. > On the after update event of the amount field, you can write the code > Me.Refresh [quoted text clipped - 9 lines] > > Any suggestions? > > Thanks in advance It will trigger the after update event of the field, only when you exit that field. SignatureI hope that helped Good luck > Hi Ofer and thanks for the reply. > The problem is that the procedure doesn't trigger the AfterUpdate event at [quoted text clipped - 14 lines] > > > Any suggestions? > > > Thanks in advance |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.