Return an image in a drop down box in a form from the database dropdown

[cyndiperr]

OK - I am an occassional Access user. I have created a database and then a corresponding form I am going to use as a report off of the info. I would like (for presentation purposes) to figure out how to create a drop down menu in the database that will return an image for that field and then have that image show up in the form. I need to be able to choose from three images.



Can that be done - if so how?

[cyndiperr]

nobody can answer my original post? I really want to figure out if this can be done or not. PLEASE HELP - Thanks!

OK - I am an occassional Access user. I have created a database and then a corresponding form I am going to use as a report off of the info. I would like (for presentation purposes) to figure out how to create a drop down menu in the database that will return an image for that field and then have that image show up in the form. I need to be able to choose from three images.

Can that be done - if so how? IF it can't could someone just please tell me. I have imbedded an OLE object but can't figure out how to get a drop down to return an image.

Any response is appreciated - Thanks!

[amrut]

-Add one image control and combo box to the form say cmbImageList and ImageToDisplay
-Store all the images in a folder and their full paths as row source for the cmbImageList. You can use more columns in the combobox to hide the actual path and show custom image names.
Add following line to the cmbImageList's after update event -
Me.ImageToDisplay.Picture=Me.cmbImageList

[June7]

Possibly don't even need code.

Set the Image control ControlSource property with an expression:

=[cmbImageList]