I thought we discussed this. The reason for making the crosstab was so that you could bind the position combos to the crosstab and use the table to pick up the description of the extinguisher using the RowSource of the combo because you wanted a simple way to color the pictures of the extinguishers.
If you need the positions to be updateable, then get rid of the crosstab and put the positions in the subform instead of as unbound controls on the main form. Then to colorize the pictures, you need to loop through the subform.
OR
You can leave the main form bound to the crosstab but hide the position fields. Use the positions in the crosstab to set the colors but use the subform if you need to update the extinguisher. You need to requery the mainform in the AfterUpdate event of the subform to make the change visible in the main form though
