Sub Form Settings

[Mike Franey]

Hi Folks,

I have a main form with a continuous sub form, I would
like to set the back color in the sub form based upon
data in the incomminng record, e.g. when a stoplight
field has the word 'red' in it I would like to set a sub
form field to a back color of red.

I am able to do this for the first record, but then it
sets all the subsequent sub form fields the same color.
I have tried 'on current' and all the other 'on...' event
procedures, with the same results, both at the form and
sub form levels.

Is there a way to control individual fields in a
continuous sub form?

Thanks,

Mike