Also, now I'm at the point where I am trying to calculate the TransSubTotal, TransDiscount, TransTax, and TransTotal values for the entire sale, but I seem to be getting no output. I tried to make this line:
Me.TransSub = Me.ItemCost
and realized I wasn't sure how it would gather "all" the line's ItemCosts to make one sub total. Then, I realized in the table that each item added has its own "Sub, Tax, Discount, Total" fields in the table, even if they aren't populated. What's the ideal way to total these up and run some more math on them, obviously, having the TransItems table hold all the totals as well?