Show Images Dependent on Field

[jrshaw03]

Hello all,

I have a simple form that shows some data from a main table and 1 OLE Object. The OLE object is 1 of 5 images of the US all in different colors. The image that is shown depends on the value of a "Rating" field. Also the images are stored as records of type OLE OBJECT in a seperate table. This works fine but I would like to expand the form to include 5 images of Mexico in differnet colors.

Is it possible to create an Object frame that can check a field to determine country of origin and rating and then select the correct record source to get the correct country and color?
If so, where would I do this, within the expression builder or vb?

Thank you very much,

Jimmy Shaw

 

[TheAceMan1]

How are ya jrshaw03 . . .

Before you get to deep in this, take a good look at the following: Handle/Display images in forms/database

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]