Hey all,
I am having an issue with some custom VBA code that we use to display a variable in the SOP Entry window,
In 2015 I could use the statement:
customfield.Value = variable
In 2015 R2 this occasionally throws an odd error "1007". I have read a KB article and some other online resources about how to solve this, and apparently this method can cause some business logic errors.
The resolution is to instead use something with this syntax:
customefield.focus ("variable").
Great, easy fix right? Well now I am not getting anything to display in the customfield. I've even tried changing the entirety of the code once to first set focus without the variable, and then a sub aftergotfocus for the field to set the variable. Nothing, nada. I've put some checks in place to ensure that the sub aftergotfocus was running and it seems to never even run through so I believe something is going wonky with the .focus method. Does anybody have any ideas, or have experienced this in the past?
Thanks
*This post is locked for comments