displaying embedded image in unboud form

[Jikra]

I've a table (cust) with a OLE Object field (flag) containing (small)
embedded bitmap images. These images display fine in a form bound to the
table.

I now want to display them in an unbound form, referencing another field in
the "cust" table (like select flag from cust where language = 'EN') to show
the English flag.
I've tried the image control, bound and unbound objects on the unbound form.
I cannot find how to configure the settings of either of those to display the
embedded picture.

Please do not answer with solutions with linked images. I know how to do that.

 

[Tom van Stiphout]

On Sun, 31 Jan 2010 05:42:01 -0800, Jikra

Ignoring your last sentence: why not use a small subform which only
purpose is to display a bound object control, bound to the table?

-Tom.
Microsoft Access MVP

 

[Sylvain Lafontaine]

You could try with the DLookUp function as the Control Source (don't forget
to put an equal sign before) as this was working with reports, if I remember
correctly. Don't know if this will work with a form.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Blog/web site: http://coding-paparazzi.sylvainlafontaine.com
Independent consultant and remote programming for Access and SQL-Server
(French)