I’m allowing people to make a edit from an embedded view on a form. As a result their chage requires that I recompute a field on the document from which they made they made the view edit. I’ve tried to do this in two ways without success. I have a computed field on the form, but it only updates if the person actually double-clicks to go into the document, then does an edit/save/close. This defeats the purpose of having them edit the document at the embeded view level. The other method I’ve tried is to put the following code in the inviewedit function of the view, but I get a type mismatch:
Case SAVE_REQUEST
For i = 0 To Ubound(Colprogname) Step 1
Select Case Colprogname(i)Case “Quantity_Changes_New_Qty”
Call doc.ReplaceItemValue(“Quantity_Changes_New_Qty”, Cdbl(Columnvalue(i))
Case “Quantity_Changes_Designators”
Call doc.ReplaceItemValue(“Quantity_Changes_Designators”, Ucase(Columnvalue(i)))
End Select
Next
HERE’S WHAT’S NOT WORKING===>
If doc.GetItemValue(“Quantity_Changes_Price_Per”)(0) <> “” Then
Call doc.ReplaceItemValue(“Quantity_Changes_Total_Diff”, _
' ((doc.Quantity_Changes_New_Qty(0) * doc.Quantity_Changes_Price_Per(0)) - _
' (doc.Quantity_Changes_Current_Qty(0) * doc.Quantity_Changes_Price_Per(0))))
End If
Call doc.Save(True, True, True)
Call workspace.ViewRefresh
End Select
You’re help is appreciated, my deadline is Thursday AM!!