How to open a file from my documents

[newbie87]

Hi,

I have a form which has a hyperlink textfield which holds a unique ID number, the user can click this hyperlink to open a new modal form.
'The modal form holds the file location based on the unique ID and I wish to have an image appear below based on the file location.

So for example in the modal form the file location is c\Drawings\images\image1.gif (the file location can be different at any time), is there anyway to open this image on form load?

The file location is held in my table and is found using the code below:

Me.DrawingLocation = DLookup("FileLocation", "ImageData", "UniqueID = '" & Forms!frmHome!UniqueID & "'")

Many thanks in advance

 

[vbaInet]

You can use an Image control. Just set the its Control Source property to the image path.

 

[newbie87]

Many thanks this works.

You have helped me quite a few times over the past week or so, really appreciate it!

 

[vbaInet]

Glad to hear!