change image based on combo box selection

[cpotter]

Hello! I am new to this forum and this is the first time I have posted.

I have a picture/image field on form that needs to update based on combo box selection. The number of choices from the combo box is great. How would I code this so the corresponding picture changes? I have seen answers based only a few images, but my combo box has quite a few choices each matched to a picture.

Thanks you,
CPotter

[June7]

Is the picture embedded in Attachment field or saved externally? Can use an expression in Image control ControlSource property to construct path to external image.

[cpotter]

Is the picture embedded in Attachment field or saved externally? Can use an expression in Image control ControlSource property to construct path to external image.

The pictures are saved externally in same drive, different folder.

[June7]

So what does the combobox have - full file path and filename with extension (.jpg, .bmp, etc)?

[cpotter]

So what does the combobox have - full file path and filename with extension (.jpg, .bmp, etc)?

I apologize, I think I was not clear before. The combo box is ID numbers, as text field though. I need to know how to connect the combo box info (the ID numbers) to the corresponding picture (named same as the ID number) so the picture changes when the combo box selection changes.

[June7]

Need full file path for the image in the ControlSource property. This can be changed dyanmically by an expression that references combobox. Are all images in the same folder?

ControlSource expression like:

="C:\folder path\" & [combobox name] & ".jpg"

If the folder is on central server and this db will be used on multiple computers, suggest using UNC path instead of static drive mapping.

= "your server name\\folder path\" & [combobox name] & ".jpg"

[cpotter]

Need full file path for the image in the ControlSource property. This can be changed dyanmically by an expression that references combobox. Are all images in the same folder?

ControlSource expression like:

="C:\folder path\" & [combobox name] & ".jpg"

If the folder is on central server and this db will be used on multiple computers, suggest using UNC path instead of static drive mapping.

= "your server name\\folder path\" & [combobox name] & ".jpg"

Does this path need to be in the control source of an unbound object or in image field. Here is what I put in my controlsource ="M:\Access Stuff\Pics" &[comboboxname]&".jpg" for the image It did not bring anything up. If I point it to a particular picture is does not change. Do I need to include a requery or put something in the after update on the combobox events. Also, thank you for putting up with basic questions.

[cpotter]

Okay, I think I am getting there. Right know if will go to the first selection, but after that is it will not change again.

[June7]

I've actually never tried to use combobox as parameter for Image control ControlSource. I have used dynamic expression that references a field of the form RecordSource. In that case the Image control reflects correct image for each record. What you are doing should display same image for all records of the form. Might have to refresh the form, in which case the form will automatically move to the first record.

I don't have time right now to build something and test. If you want to provide db, follow instructions at bottom of my post.

[ItsMe]

Does this path need to be in the control source of an unbound object or in image field.

I use an image control to dynamically display images on a form. When I first create the control, I have the wizard turned on. I select a temp image that is sized approx. to the size I will be using in my form.

After I create the image control I give the control the name I want and save the form.

Then I clear the Picture property for the Image Control. Access will ask you if you want to delete the image. Answer yes and save the form.

Now you can dynamically update the Picture property of the Image Control. Use your image path as June7 explained in post # 6

[cpotter]

Thank you for all your help, but I think I have it figured out. I coded the following a test db in the after update of the combobox:

me.[image name].picture="c:\\filepath\"&[comboboxname]&".jpg"

I will code my db at work on Monday and cross my fingers.

[statman]

Another good place to store the pictures is on dropbox public file or something similar so that anyone who is using your program does not have to set the database paramaters.