Trouble with Lookup Macro

[RammerJammer1674]

Hi everyone.

I'm having problems with the very last line of my macro. It's a SetReturnVar. When I set the Expression= some arbitrary value it works. However, when I set the Expression = VendorName, the way it needs to be, it gives me an error saying the identifier could not be found. Any help? Thanks!


PS, please see attached jpg to view my code.

 

[George-Bowyer]

Have you tried looking up the record in PurchaseOrders itself rather than on a select clause based on PurchaseOrders?

 

[RammerJammer1674]

Have you tried looking up the record in PurchaseOrders itself rather than on a select clause based on PurchaseOrders?

Yes, I have. But that's not the line that is giving me problems. It works in some of my other macros. Just not this particular one. It's just my SetReturnVar that is giving me errors.

 

[RammerJammer1674]

Yes, I have. But that's not the line that is giving me problems. It works in some of my other macros. Just not this particular one. It's just my SetReturnVar that is giving me errors.

Bump. Can anyone help at all?