Master-Detail Datagrid sum up problem

[Agnes]

I got master-detail datagrid
in my datagrid (invoicedetail) , aim(as the user type the unit price or no
of unit), the amount will be calculated and the TOTAL amount can be showed
in the form at once.

In my columnchanged event
e.Row("invamt") = e.Row("unitprice") * e.Row("noofunit") *
e.Row("exrate")
drInvInfo =
Me.dsSeaInvInfo.Tables("invoiceHeader").Rows(bmSea InvInfo.Position)
For Each drInvCharges In drInvInfo.GetChildRows("fk_invno")
decTtlAmt = decTtlAmt + drInvCharges("invamt") <--- it
seems fail
Next
Me.txtTotalAmt.Text = decTtlAmt
How can I sum up the detail tables before I update the tables ??
Thanks

[Ken Tucker [MVP]]

Hi,

Try this.

decTtlAmt = decTtlAmt + Cdec(drInvCharges("invamt"))

Ken
---------------

"Agnes" <ag***@dynamictech.com.hk> wrote in message
news:OQ**************@tk2msftngp13.phx.gbl...
I got master-detail datagrid
in my datagrid (invoicedetail) , aim(as the user type the unit price or no
of unit), the amount will be calculated and the TOTAL amount can be showed
in the form at once.

In my columnchanged event
e.Row("invamt") = e.Row("unitprice") * e.Row("noofunit") *
e.Row("exrate")
drInvInfo =
Me.dsSeaInvInfo.Tables("invoiceHeader").Rows(bmSea InvInfo.Position)
For Each drInvCharges In drInvInfo.GetChildRows("fk_invno")
decTtlAmt = decTtlAmt + drInvCharges("invamt") <--- it
seems fail
Next
Me.txtTotalAmt.Text = decTtlAmt
How can I sum up the detail tables before I update the tables ??
Thanks