I have a list lookup form control that is looks up a string in another form based on whether the User entered into the form is the same as the User in the lookup list.
This control works GREAT in New Mode and in Display Mode (it shows up as a hyperlink of the string, linked to the other List). However, in Edit Mode it displays the User but NO lookup value, and if you re-enter the User OR a new User, nothing displays! I am very frustrated and have spent a lot of time trying to figure this one out.
Here is a screenshot of the lookup settings:
And one of how it fails in Edit Mode:
Help?