Open image based on two field values

[mainerain]

Depending on the value in each of two fields I want to open a particular image. There will be many different text in Field1 and in Field2 to choose from, with many images to pick for an output.

Do I create a table that comes up with all the possibilities? When I click on a button the vba would get the values from Field1 and Field2 and somehow know which image to open, which I assume would be a Hyperlink.

Hopefully that doesn't sound to convoluted.

Thanks

[Welshgasman]

I would. The image path would be in a field.

[Micron]

Either a table or assign the image control picture property by way of a Select Case block. The table idea makes the task much more flexible IMO.

and somehow know which image to open

Could return that path with DLookup using the 2 fields as criteria or open a recordset (more complicated) and assign it to the control property.