I got a basic invoice form that has a 'line total' (in a subform but i'm keep the invoice total in the subform), I want it to total all the 'line totals'
I have 'invoice total' in a table to record invoice total but i cant seem to get anything to work, it either errors or just doesnt do anything at all.
Many Thanks.
I have 'invoice total' in a table to record invoice total but i cant seem to get anything to work, it either errors or just doesnt do anything at all.
Code:
Private Sub Product_Code__AfterUpdate()
Dim ltotal As Double
Me.Product_Description_ = Me.Product_Code_.Column(1)
Me.Sales_Price_ = Me.Product_Code_.Column(2)
Me.VAT_Code = Me.Product_Code_.Column(3)
Me.VAT_Percentage_ = Me.Product_Code_.Column(4)
Me.Obsolete_ = Me.Product_Code_.Column(6)
Me.Line_Total = Me.Sales_Price_ * Me.Qty
ltotal = DSum("[Line_Total]", "Orderline")
' Me.Invoice_Total = DSum("Line_Total", "Ordeline")
End Sub
Many Thanks.