Linking images to a record

[jbradly]

I have a database with records of name, id number, and photo (which is displayed in the table as a unique photo name for each record). I want to create a justified form that shows the correct picture with the name so that as you scroll through the form you can see the photo, name, and ID of each individual. I am using Access 97 and I cannot upgrade to 2000. I could cut and paste each picture but I have over 3000 records and I don't have a lot of time. Any suggestions?

 

[OutbackInvestments]

Cant you set the field picture to OLE data type and do it that way?
Then, if you need it automatically, I think this works.
Form_On_Current:
[Picture]=[Name]&".jpg"
I think that might get it to work.
Hope it helps