I have a matrix with a DBDatasource tied to it. I have a total column at the end of the matrix which I want to update with the total for that line. This doesn't seem to be working. I am running this on the lost_focus event.
I have included the code below, can anyone suggest why it may not be updating please ?
For lc = 1 To nodays tot = CCur(tot + Val(omatrix.Columns(lc).Cells(pVal.Row).Specific.String)) Next omatrix.GetLineData (pVal.Row) oform.DataSources.DBDataSources(0).SetValue "u_total", pVal.Row - 1, tot omatrix.SetLineData (pVal.Row)