Hello,
I am trying to use the User Information List and have been following these directions: User Information within InfoPath Forms. The only difference is I am setting the default value for some of the InfoPath fields to the UIL data values rather than just dragging the UIL data fields onto the form. It works wonderfully except that it always populates the fields with data from the current user and I need the data from the original user to remain in the list, even when the list item is reopened. If I uncheck "Refresh value when formula is recalculated" under "Text box properties" then the original data stays in the list. However, when adding a new record the fields that get their default values from the UIL data fields are now empty.
I tried using the User Profile Service (UPS), which works in InfoPath, but there appears to be a network or server security setting that is causing the dreaded "5566" error when the form is opened in the browser.
Does anyone have a solution on how I can pull the UIL data on new records AND still keep the original users profile information in existing records when they are reopened? Thanks in advance.
Ken