Displaying JPEGs in a form using directories stored in text fields

[TOTCOM11]

I have a product database and would like to have up to three jpegs display for each product (each record). I am currently using Access Object Frames to display the jpegs from three text fields: Pic1, Pic2, and Pic3 (one for each possible picture). Some records may only display 1 or 2 pictures. In the case of just one picture, the text fields Pic2 and Pic3 are plank. The names of my controls are PICTURE1, PICTURE2, and PICTURE3. I am having the hardest time trying to get the images to display. Here is my current code:

Private Sub Form_Current()

'Code to link pictures
Dim strPath1 As String
Dim strPath2 As String
Dim strPath3 As String

    On Error GoTo err_Current

    strPath1 = Nz(Me.Pic1)
    strPath2 = Nz(Me.Pic2)
    strPath3 = Nz(Me.Pic3)

    Me.PICTURE1 = strPath1
    Me.PICTURE2 = strPath2
    Me.PICTURE3 = strPath3
'End Code to link pictures
    
exit_Sub:
    Exit Sub
    
err_Current:
    MsgBox Err.Description
    Resume exit_Sub

End Sub

When I move from record to record, I do not get any error messages. Can anyone help me?

 

[markphsd]

Use unbound pictures, with the picture.path of the object set to the path of thepicture.

Mark P.

http://www.cafecartel.com

Providing Low Cost Powerful Point of Sale Solutions.

 

[VBslammer]

You should be using Image controls with their "Picture Type" properties set to "Linked." Then you can assign the paths like this:

Me.PICTURE1.Picture = "C:\Windows\Coffee Bean.bmp"
or
Me.PICTURE2.Picture = strPath2

VBSlammer

Unemployed in Houston, Texas

 

[VBslammer]

You might be able to right-click them and select [tt]ChangeTo -> Image[/tt]

VBSlammer

Unemployed in Houston, Texas

 

[TOTCOM11]

Thanks Slammer, your first point helped me tremendously, and unfortunately, with image controls, you cannot change them between bound, unbound, and image.