Add an image based on field result

[Juniorz]

Hello,



I am creating a student record form, which is self entered by a teacher. Im having trouble trying to add a image from a directory on the computer. i do not wish to add images to the database but link them in.

The photos are all stored in a set folder directory, these photos are all named after the student ID number.

What i'm trying to do is when a students number is entered in the student ID field the image box can pick this up and display the appropriate picture from the folder.

Any help appreciated.

[June7]

Use an Image control. Set its ControlSource to an expression that concatenates the folder path with the student ID number, like:

="C:\path\" & [StudentID] & ".jpg"

Where is the photos folder located - on a network file server?

[Juniorz]

oh sweet, its beautiful. Thanks!

Yeah on a network server. Curious though. If a user doesn't have permission to this folder will they see the photo?

[June7]

Probably not. Need at least read permission.

Is this a split db and each user runs their own copy of frontend?

If you use drive letter path in the expression, each user must have that drive mapped by Windows on their machine. Use UNC path in the expression and drive mapping is irrelevant.

="\\server name\path\" & [StudentID] & ".jpg"