I have a continuous subform that displays records with color (RGB) data. I would like each record to display a color "chip" field whose color is based on the RGB values that are also present in each record. I have code that sets this color for each record (using the On Current method), but all records on the subform change to the current record's color value when changing records.
Is there any way to set the color by record, and have it display correctly so that the user does not have to select each individual record to see the color display?
I am using Access 2007, Win XP Pro (SP2).