display image in a subform

[LPayne]

I have developed a form which contains a subform. The subform contains a bound image for display. Think of a 'department' form with 'employee' records on the subform containing an employee photo. (Very standard stuff.) It used to work correctly but I must have inadvertantly changed something but cant find it.

The problem is that the photos don't display at all as I move through the department records - using the main form's navigation. I need to use the subform navigation to show any of the photos. When I get a photo to show for a particular department then I can navigate through all the employees in that department and their photos display correctly. (If I run the subform separately then the photos display correctly too.)

Any ideas?

The properties which seem to be relevant are

Bound Object Frame:
Display Type = Content
Update Options = Automatic
OLETypeAllowed = Embedded
Enabled = Yes
Locked = Yes
AutoActivate = Manual

Subform:
Enabled = Yes
Locked = No


thanks

LPayne

 

[GabrielR]

Not quite sure, but it could be the Autoactivate property.

Anyway, storing pictures on a database has shown to be not a very wise practice.

I would suggest you to store the Path of the picture and have the image bound to the path of the picture.

 

[LPayne]

Doesnt help

I've changed the subform so it includes a link to the image. That doesnt help (but I dont think GabrialR thought it would).

I've also changed Autoactivate and tried both manual and double-click but neither resolve the problem. Indeed I now sometimes get the wrong image displayed!

Other ideas please...

LPayne