Question:
We have a picklist field on the Insert Opportunity form that, when selected, is not showing in the corresponding field on Opportunity Detail. I’ve checked the data paths on both fields and they are pointing to the correct location. I also checked the script but couldn’t find anything there. How do I make the field from the Insert Screen write to the database and display in the Detail view?
Answer:
Did you modify the code on the Insert Opportunity view?
As far as I recall, this is not a bound view, and as such it is not enough to drop a control and Bind it (Binding it makes no difference), you have to add some code to save your data.
If you look on the Code, there is a SaveOpportunity function, which calls several other Save functions to create the Opportunity. If your data goes on the OPPORTUNITY record, edit the SaveOpportunityDetailInfo, and add your value to the record before it is saved:
objRS.Fields(“MYPICKLISTFIELD”).Value = myPicklistControl.Text
….
objRS.Update
