Image change based on combo box

[bosve73]

Hi

I have very simple database consisting of one table "tblMain" and one form
"frmMain". On the form i have a two cascading combo boxes and two text box which get their data from combo boxes.



The issue that I have is I am trying to add image to my form which is based on selection in a combo box so that Selection1->shows image1 and so on. As a novice to Access I have searched the forum but there are so many diffrent solutions that I don't know where to begin.

[trb5016]

First on your form add an image as a placeholder. Do this by selecting the Image button (near textboxes and combos etc)

Drag it over the area you want to cover. It will ask you to select an image. I'd choose whatever picture you want the default to be. (I'm pretty sure it forces you to have some image in there, though I could be wrong - you might also be able to use an unbound object frame, anyone?)

Now change the Control name of this image to something better than Image1 or whatever.

Now on your combobox, use the "AfterUpdate" Property. In there put code that could look something like this

Select Case [YourComboBox].Value

   Case "Choice 1"
      [YourImageName].Picture = "C:\YourPathToPicture\YourPicture.jpg"
   
   Case "Choice 2"
      [YourImageName].Picture = "C:\YourPathToPicture\YourPicture2.jpg"

End Select

You can of course have a bajillion ways to choose the image other than a select case, but that's what I normally use for comboboxes

The important property here is the .Picture

[bosve73]

First on your form add an image as a placeholder. Do this by selecting the Image button (near textboxes and combos etc)

Drag it over the area you want to cover. It will ask you to select an image. I'd choose whatever picture you want the default to be. (I'm pretty sure it forces you to have some image in there, though I could be wrong - you might also be able to use an unbound object frame, anyone?)

Now change the Control name of this image to something better than Image1 or whatever.

Now on your combobox, use the "AfterUpdate" Property. In there put code that could look something like this

Select Case [YourComboBox].Value
 
   Case "Choice 1"
      [YourImageName].Picture = "C:\YourPathToPicture\YourPicture.jpg"
 
   Case "Choice 2"
      [YourImageName].Picture = "C:\YourPathToPicture\YourPicture2.jpg"
 
End Select

You can of course have a bajillion ways to choose the image other than a select case, but that's what I normally use for comboboxes

The important property here is the .Picture

I am probably missing something but it does not work when i test it.
No errors at all but nothing happens either when I do a selection in combo box.

[trb5016]

Hrm, is the event actually being fired? Try putting a line of code to debug like

Msgbox("This should be changing the picture now")

Also I whipped up a quick sample for you (Attached)

[bosve73]

Hrm, is the event actually being fired? Try putting a line of code to debug like

Msgbox("This should be changing the picture now")

Also I whipped up a quick sample for you (Attached)

Ok i got it working now. Thanks!