Solved Inserting an image from a table onto a form dynamically

[Sam Summers]

Hi,

Not sure if this is possible?

I have a table of items that are used for records in a field of the main table.
So in the lookup table:

Item 1 is a purple disc (BMP object)
Item 2 is a red disc (BMP object)
Item 3 is a blues disc " "
and so on

So when the related record in the main table is chosen from a combobox the associated colour disc is displayed.

Basically what i am trying to do is place the coloured discs on a floor plan to indicate the different fire extinguishers at each position.

Many thanks if you understand me and can help in any way

 

[theDBguy]

I don't think I fully understand your question, but one possible approach is to put all the images on the form and just display the selected color and hide the rest.

 

[Ranman256]

Image0.Picture = "c:\temp\cat.bmp"

if path is in a field:
Image0.Picture = txtBoxPath

 

[CJ_London]

if these are all discs then could use a button shaped as round - can then set colour as required

 

[Sam Summers]

Thank you guys for all your replies. They are ideas to consider. I will come back here to conclude later

 

[Sam Summers]

Hi Guys,

To conclude then - I used CJ's method which is working very well but i understand that earlier versions of Access do not have this ability.
Thank you everyone