Hi All
i am trying to calculate Quantity on hand in a unbound textbox in a
form [FrmMainListing] with a subform [FrmSubListing]
QonHand=Qreceived - TotalQSold
TotalQsold=QsoldOnEbay+QsoldThruOtherChannels
here is my expression:
= [Ir0n] - ( ( DSum ( "[Sq0]", "tblSold","SlistingID" =
"[FrmSubListing].Form![ListingID] ) + (DSum
("[ocQ0N]","TblOtherQandL","oItemID" =
"[FrmMainListing}.Form![iItemID]))