Continous Form Pictutes

[ppkgoldengun]

Hi,

I have created a form in which I assign a image to a unbound image field based upon the following code that has a field on the form that contains the path to the image. In the past I have used this on a single form and in the on current event. However, I need this in a subform that is continous form showing multiple records with each image corresponding to path field. Right now each record say 2 or 3 shows the same image unless you move to another record. So the on form current event doesn't work. How can I show a image that is assigned from another path field for each record in the subform. My current on Form Current event form is:

On Error GoTo err_Form_Current

If Not Me!txtMicroPhotoLoc = "" Or Not IsNull(Me!txtMicroPhotoLoc) Then
Me!Picture.Picture = Me!txtMicroPhotoLoc
Else
Me!Picture.Picture = "C:\UCSF\ucsf-logo-r2.jpg"
End If


exit_Form_Current:
Exit Sub

err_Form_Current:
MsgBox Err.Description
Resume exit_Form_Current


Any help is greatly appreciated.

 

[stix4t2]

You must use a bound image box so you cannot do it through code.