Populate text box with attribute value

[rasmusborgstrøm]

Hi

I want to populate a value of an editfield (text) based on an attribute in the shapefile.
I have tried out this in the Page setactive event, but this doesn't work.

Application.Map.Layers.Item("TransectWalks_points_JUNO1").Forms.Item("EditForm").Pages.Item("Location").Controls("editPHOTO").Value = Application.Map.Layers("TransectWalks_points_JUNO1").Records.Fields("PHOTO").Value

Does anyone have a suggestion on how to access the value in the attribute table and populate this to a field?

Best regards,
Rasmus