Hello,
Nobody seems to know how to help me - can you? - Third time lucky!
I am in an Outlook Form and want to set a User_Defined Field to a value in another "DataRecord" form. The DataRecord Form is an Outlook "Document Form" based on Excel.
The code below works - it finds and displays the "DataRecord" I'm after by Serching for "OpNo" - which is a User_Defined Custom Property on the Excel Form..
Sub cmdOpenDataForm_Click
Set myItems = oDataFolder.Items
Set oCriteria = item.userproperties.find("Criteria Field"
FinString = "[OpNo] = """ & oCriteria &""""
Set DataRecord = myItems.Find(FinString)
DataRecord.Display
end Sub
What I can't get to work is reading in the data I need.
I've tried adding to the above in all sorts of variations for example ....
Set oReadInData = Financials.userproperties("Data"
item.userproperties.find("RetrievedData" = oReadInData
but no Joy.
Can you help?
Thanks
Grippen
Nobody seems to know how to help me - can you? - Third time lucky!
I am in an Outlook Form and want to set a User_Defined Field to a value in another "DataRecord" form. The DataRecord Form is an Outlook "Document Form" based on Excel.
The code below works - it finds and displays the "DataRecord" I'm after by Serching for "OpNo" - which is a User_Defined Custom Property on the Excel Form..
Sub cmdOpenDataForm_Click
Set myItems = oDataFolder.Items
Set oCriteria = item.userproperties.find("Criteria Field"
FinString = "[OpNo] = """ & oCriteria &""""
Set DataRecord = myItems.Find(FinString)
DataRecord.Display
end Sub
What I can't get to work is reading in the data I need.
I've tried adding to the above in all sorts of variations for example ....
Set oReadInData = Financials.userproperties("Data"
item.userproperties.find("RetrievedData" = oReadInData
but no Joy.
Can you help?
Thanks
Grippen