Inserting Photo's to specific forms and linking to a file

[Johanvdw]

Exactly what do you not understand about concatenation? Doesn't matter how many fields are involved, it's still concatenation.

="Z:\FSE\8. FSE - Storage\" & [UNIT] & "\" & [Howden Project No] & ".jpg"

Thank you. It is working. To be honest, I don't know a thing, but learn from guys like you!

 

[Ken Sheridan]

I have a similar problem. My link must use 2 fields to select the correct pic in the specified folder to insert the correct pic in the photo field. Can you please help with the correct way of doing this? The two fields to identify the correct pics is used in this link: ="Z:\FSE\8. FSE - Storage\[UNIT]\" & [Howden Project No] & ".jpg"

The attached zip archive includes a number of files of varying degrees of complexity which illustrate how image files can be associated with records in a database, using the methods described in this thread. The basic Images_Simple.accdb file should suit your requirements.

 

[Mark_]

Special note for images, you will want to make sure they are in PNG format to avoid some not rendering when loaded into an image control.