Multiple picture change subform focus

[ZOMB13]

Hi all,

Is it possible for an image control to change to a different picture on a form when focus changes to a different record on a subform? I am developing a simple database to record my ever growing collection of TV shows. The form that I use to view my TV show records has an image control on it, I previously had a single image for the entire series (box art for first season). I now want that image control to change to a different picture when the focus changes to a different record on the subform. Ie. when the focus changes from the first season on the subform to the second season; the picture on the main form changes with it. Hope this makes sense. Thanks in advance.

ZOMB13.

[trevor40]

Yes it is, but i did this so long ago i forget how i did it. but when the record in the sub form changes just update the image on the main menu with the details for the selected record in the sub form. it has to be a full path - c:\aaa\pic.jpg saved in a related field to the show.

[ZOMB13]

I found this http://www.experts-exchange.com/Data..._28269209.html I think that’s what I’m looking to do, but I can’t seem to make it work on my db. Someone must be able to enlighten me?

[ZOMB13]

TVDB.zip Thought I might upload my db so that it’d make it easier to understand what I’m trying to achieve. Thanks.

[ItsMe]

Pic_Dynamic_Path.zip
Here is an example.


I placed three photos in a subfolder to the DB's path. The subfolder's name is hardcoded in the form's current event. The file names are in their respective records within the table.

To do this, I create an image control and adjust its PictureType property to Linked. When I create the image control, I use one of the actual pictures that will be used by the DB. This helps with picture sizing. Then, I will change the property to linked. Then, add the VBA.

[ZOMB13]

Pic_Dynamic_Path.zip
Here is an example.


I placed three photos in a subfolder to the DB's path. The subfolder's name is hardcoded in the form's current event. The file names are in their respective records within the table.

To do this, I create an image control and adjust its PictureType property to Linked. When I create the image control, I use one of the actual pictures that will be used by the DB. This helps with picture sizing. Then, I will change the property to linked. Then, add the VBA.

ItsMe,

Thank you for your response, however I don’t believe that is what I’m trying to achieve (see original post). Take a look at my database that I uploaded, It might make more sense than my ramblings. Thanks,

ZOMB13.

[June7]

Image control has a ControlSource property (starting in Access 2007). The property can be bound to an attachment type field that holds image files or to a text field that has path to external image file. It can even be an expression that concatenates a string with a field - so if that field has only the image name:

="C:\path\imagefolder\" & [fieldname]

I suggest you have image name in the Picture field in SEASONS table, then ControlSource expression like:

="driveletter:\path\imagefolder\" & [Seasons subform]![Picture]

No VBA needed.

[ZOMB13]

Image control has a ControlSource property (starting in Access 2007). The property can be bound to an attachment type field that holds image files or to a text field that has path to external image file. It can even be an expression that concatenates a string with a field - so if that field has only the image name:

="C:\path\imagefolder\" & [fieldname]

I suggest you have image name in the Picture field in SEASONS table, then ControlSource expression like:

="driveletter:\path\imagefolder\" & [Seasons subform]![Picture]

No VBA needed.

June7,

That’s perfect, thanks so much. I feel like such an idiot, that was ridiculously easy. I was so close yet so far. I was referencing the table in the ControlSource of the image control, when I should have been referencing the subform. Thanks again,

ZOMB13