I have a grid that displays data on an onchange event of an edit field. My next event after gathering data and refreshing the collection on that grid is to get value of a cell, put it into a formula and display the result onto another cell in the next column. Below is the code that i have so far. I can see that the cell value is changed to the new value but it's not showing up on the grid for the user to see. I'm not sure if I'm missing a step. Please advidse. Thank you
Dim oLocCache As IWSIDOCollection
Dim i As Integer
Dim tot As Double
oLocCache = ThisForm.Components("JITMatlGrid").IDOCollection
tot = 0
If oLocCache.GetNumEntries = 0 Then
Exit Sub
End If
For i = 0 To oLocCache.GetNumEntries - 1
tot = CDbl(ThisForm.Components("QuantityEdit").Value) * CDbl(oLocCache.Item(i).Properties("matl_qty").GetValueOfDecimal(0))
ThisForm.Components("JITMatlGrid").SetGridValueByColumnName(i+1,"MatlQtyActReqGridCol","99")
Next