Using images in a Folder on a report/form (1 Viewer)

[jordankoal]

I have photos stored in a folder on a drive.
I have referenced them before in a simple picture viewer I created in a form.
I create the file name by referencing the values of a list box on the field.
Example:
The list box has piid.2005.001 and image name is 2
filename = C:\Temp\" & pidd & "\" & piid & "_" & imageName & ".jpg"
C:\Temp\piid.2005.001\piid.2005.001_2.jpg
Each piid has it's own set of photos in their own folder

Now. I want to be able to print out all the files in a report/form.
The piid and image name are stored in a table called tblPhotos so I could reference there.
I want to have a button I click that generates a report/form that spits out all the photos in that folder. Next to a button would be a text box (txtWhichPiid) where you enter in the piid and that's how you know which piid's photos to use.

 

[Simon_MT]

Create a Report with a Query of all the piids and Image_Names as you have stored these values.

Create an Image Control and its Control Source of:

="C:\Temp\" & [pidd] & "\" & [piid] & "_" & [imageName] & ".jpg"

Simon

 

[jordankoal]

Awesome! It is giving me 4 outputs per picture though. Any ideas why?
EDIT- Nevermind... I had another table in the query for some reason, problem solved. Thank you very much Simon for all the help.