Picture which changes when a selection is made

[t406jaw]

I have a combo box which contains a list of names below this there are two sub forms. When a name is selecte from the combo box details of that person appear, is it possible to assign a picture to each person. ray: ray:

 

[Dugantrain]

In your table that stores your names, you need to add an OLE field which will store pic info.

 

[t406jaw]

This sort of works but it only displays an icon to get the picture you have to double click on the icon any ideas on how to get the picture to open itself on the subform.

thanks. ray:

 

[Dugantrain]

I'm not exactly sure. If you have the Northwind sample database that comes with Access, I know that there is a form on there which does exactly this, but I deleted my sample copy long ago. There's probably a copy somewhere on this site if you have a look around.

 

[t406jaw]

any ideas on what i should type in the search engine