Photo in Contious form

[mr moe]

I have designed a form that displays the photo thru a photo path, the problem is that when I change the form to continous form, only the first images shows for all records, until i click on the second record it displays the second photo for all records. I know this is happening because of the oncurrent event which is on the main form, does anyone know a trick to this or a solution? Thanks.

 

[Alisa]

I have designed a form that displays the photo thru a photo path, the problem is that when I change the form to continous form, only the first images shows for all records, until i click on the second record it displays the second photo for all records. I know this is happening because of the oncurrent event which is on the main form, does anyone know a trick to this or a solution? Thanks.

This is one of the lovely "features" of access. One way I can think of is to take the picture control off of your continuous form, and put it on a separate popup form, then, only display it when the user clicks on or mouses over something on the continuous form.

Another solution I have used in the past is to create an unbound form with hundreds of empty picture boxes on it. Then, in the on load event of the form, I load one picture into each box, and hide the empty ones. It's a pain, but if you really need more than one picture at once, I don't know if there is any other way.

 

[mr moe]

Thanks I ended up doing what you suggested, I put the pic in the header of the form and I displayed it on click even of each record.

This is one of the lovely "features" of access. One way I can think of is to take the picture control off of your continuous form, and put it on a separate popup form, then, only display it when the user clicks on or mouses over something on the continuous form.

Another solution I have used in the past is to create an unbound form with hundreds of empty picture boxes on it. Then, in the on load event of the form, I load one picture into each box, and hide the empty ones. It's a pain, but if you really need more than one picture at once, I don't know if there is any other way.

 

[Alisa]

You are welcome, I'm glad that you found a solution.