Bound Images

[Mike]

Hi,
I was wondering if anyone can help.
I'm trying to have a bound image in my form, the path of which will be made
up of several different text box conents.
i have the image frame (ImageFrame) and can get it working using one text
box (ImagePath) from a table, using the following code.

Private Sub Form_Current()
On Error Resume Next

ImageFrame.Picture = Me![ImagePath]

End Sub

However, in order to make it easier to load the pictures i want to have
something similar to the code below. (this doesn't work)

Private Sub Form_Current()
On Error Resume Next
Dim ImageNameCode As String
Dim PartialImagePath As String
Dim CompleteLink As String

ImageNameCode = Me![ImageName]
'e.g. Picture 001
PartialImagePath = Me![PartOfThePath]
'e.g. C:\Pictures\

ImageFrame.Picture = "'" & PartialImagePath & "''"& ImageNameCode & "'".JPG""
'e.g. ImageFrame.Picture = C:\Picture\Picture 001.JPG

End Sub

Please Help
Thanks