Notes/Domino 4 and 5 Forum

Hi,

I'm trying to use the Evaluate function to run a DbLookup. I'm trying to use a value from an open document to get a value from a lookup, and then assign the value from the lookup to a field in a new document. Unfortunately, the assignment of the value in the new document isn't working (I also tracked this through LotusScript). Here is an excerpt from my code:

dsFrmNm = doc.FrmNm1(0)

dsProduct = Evaluate ({@DbLookup("Notes":"NoCache";"":"";"Excel Lookup";dsFrmNm;4)}, doc)

NewDoc.dsProduct = dsProduct

I'm getting a value in the dsFrmNm variable, but nothing's showing up in the dsProduct variable.

Thanks,
Bob