Combo Box Image

[andycrfc13]

I currently have an Information form linked to an Information table with a combo box linked to an Employee table containg Employee Name and Employee Image.

I am trying to figure out a way that once I select an employee name from the combo box the corresponding image will be shown in a report.

I have searched the forums and seen solutions where the combo box links to an image shown on the same form but not any solutions to my requirements.

I would be grateful if someone could help me.

Thanks in advance

 

[Trevor G]

Create a form based on the table,

then create a combobox when the wizard starts ensure you select the first option find a value from the table.

Then ensure you have an image on the form which is a field from the table.

Select the properties of the combo box and then use the after update event and place in:

me.imageFieldName.requery

That will change the image as and when you select a name from the drop down

 

[andycrfc13]

Thanks for the reply trevor, but i tried your method and got an error say the me.imageFieldName.requery could not be found. I have changed it to refect my own fields name

 

[Trevor G]

You have to replace the image name with the object you are using

me.imageFieldName.requery

Change the imageFieldName to the name of the object

 

[John Big Booty]

Check the sample posted here