Link and load won’t populate unless I renter keyed field?

Used link/load to display fields from a different sheet. It all works Except the user must enter the field. Problem is I have 1000’s of records where the key field is already entered and when I display the record, it won’t display the linked fields unless and until a user re-enters the key field. Don’t want to have to do that. How can I make them appear automatically.


You could repoplulate loaded fields manually under design mode.