Multi-combo box to select the correct picture to be display???

[Renoir]

I hope I can explain this properly but here it goes...
I’m designing a building pass and the enrolment software links to our Access Database.
We have a combination of 3 areas to which access may need to be granted. IE, some employees have access to 1, two or all areas.
On the ID card this is represented by a strip on the left of the card; red, blue and green to represent access to area 1, 2 and 3 respectively.
Therefore if an employee has access to area 1 the strip is red.
If the employee has access to area 1 and 2 the strip is ½ red and ½ blue.
All areas the strip is 1/3 red, 1/3 blue and 1/3 green.
These colour combinations are represented by a .gif file which populated the “areas” field.
Therefore the following combinations of access are potentially granted:
1. red Area 1
2. blue Area 2
3. green Area 3
4. red / blue Area 1 and Area 2
5. red / green Area 1 and Area 3
6. blue / green Area 2 and Area 3
7. red / blue / green Area 1 and Area 2 and Area 3
There are therefore 7 .gif files that represent one of the above colour schemes.
The enrolment of a new employee will have a dropdown multi-combo box to tick the areas the enrolled employee may access.
My question is this: based on the choice made in the combo box the correct .gif file will need to populate the “access strip” field. For example, if “area 1 and 2 are ticked, the field on the ID Card needs to display .gif 4 (red/blue).
Any suggestions would be appreciated.
Cheers.

 

[Galaxiom]

Use a VBA case statement based on the combo selections.
Run this in the After Update events of the combos.

The image property is set like this:
Me!imagename.Picture = "drive:\path\file.gif"

 

[Renoir]

Thanks for this.
Is it possible to have the combo in a table and have the result of what you pick be placed in a field within the same table?
The reason I ask is that I have some software that gives me the choice of selecting fields within a database. It is not a form within Access.
Cheers.