link to 100's images based on field name

[MyWebdots]

Hi there,
I am struggling to find an easy explaination or at least one I can understand for my problem. I am newish to access having only built a couple of databases. but have found this forum great in the past.



I am reading similar solutions all over the web - but can't actually find the correct one. I would appreciate any help someone can offer please?

This is my problem.
MY DB: I have a single table and single form with text fields only.
MY IMAGES: I have a folder relative to the DB in \images\ which stores 100's images.

In the DB table I have a field with a text reference eg: ACA1 and in the images folder I have an image called ACA1.jpg

I want each record to look for it's corresponding image and display it on the form based on that text reference field.

Please see attached. I am using MS access 2007.

Any help greatly appreciated
Katie

[RuralGuy]

Hopefully this link will give you three ideas:
http://accdevel.tripod.com/imaging.htm