I have an MS Access form that includes 4 fields I need to use for a task.
When the user enters the [photonumber], the [photonumber] is added to the [photoname] and also the [photolink], creating a hyperlink for the photo.
At this point the photo is in a directory and named by the [photonumber] only. I need code to look in the directory defined by [photopath] for the photo defined by [photonumber], then rename the photo to = [photoname].
I imagine this will use VBA code in the afterupdate event of the [photonumber] field.