Binding OLE Object to Bitmap without Record Source

[Mat Son]

Hey folks.

I have a problem concerning an ole object in reports and forms which I´d like to fill with Bitmap Data from a seperate table which is not part of the record source.

The Bitmap-containing table is build up as follows:

Logos (ID, Name, Logo, Actual)

Logo contains the oleObject, Actual is a Yes/No field.

I´ll make sure that only one record can be set to be actual.

What I am looking for is some kind of solution to set the control source of the object to
"SELECT Logo From Logos WHERE Actual=-1"

Unfortunately, select statements aren´t allowed in control source fields. So how can I get the information in my oleObject?

I tried control source: "=DLookUp("Logo";"Logos";"ID=X"), just filling in a random existing ID to check if it works.. but it did not)

I hope somebody has any ideas or help,

kind regards from germany,

Matthias

[NeoPa]

Have you considered setting the Control Source explicitly with VBA code in the form's Open event procedure?

[Rabbit]

In the record source of the form, you could join your tables to pull in the ole object.