I have a form that combines a [path], [item name] and [picture number]. From this field I want to set the value of a hyperlink field, which will open the picture. I get an error code 2766, Object doesn't contain the Automation Object.." I think it might be better to use VBA than the macro.
I would like to do two things with VBA.
1) Set the Value of the LinkText field to the Hyperlilnk field.
2) Change the name of a picture to the LinkText (minus the [path] value.