Posted on 2008-11-15
Experts, I have the following DSum in the control source of [Usage] on frmFacilityDetails:
=nz(DSum("[Amount]","tblLetterOfCredit","[facilityDetailsID] = " & [facilityDetailsID]),0)+nz(DSum("[AmountDrawn]","tblDrawDown","[facilityDetailsID] = " & [facilityDetailsID]),0)
and it works great. It sums many records on tblLetterOfCredit and tblDrawDown and returns a total amount of usage. I now need to now modify it based on a cbo. I have a cbo with a "Yes" or "No" on each of the tables and when the particular amount has been repaid then a user selects "Yes" and the amount should be excluded from the DSum. The form will not be open that has the cbo.
If you need more information let me know. I am thinking that their needs to be code placed on "On Current".