W
WDSnews
I have a child table with an ID field and two number fields. The number
fields are named CountLo and CountHi and contain numbers between 0 and 12.
I want to color some boxes on a subform based on the numbers in Lo and Hi.
I've built a parent form and subform in which the subform records display as
continuous forms. I chose 'continuous forms' because I want to see several
child records at one time. The subform has 13 boxes named box0 ... to ...
box12. I want all the boxes to be white except for the boxes representing
the range from Lo to Hi. For example, if countLo is 3 and countHi is 8, I
want box3, box4, box5, box6, box7, and box8 to be yellow.
It would be easy if I could change the colors each time I change a value,
but how do I simply display the correct colors for data that was previously
entered? I've tried the Open event and a few others, but these events don't
seem to trigger with each occurance of continuous child records. They fire
once when the parent form loads, but they aren't triggered after that.
thanks for your help.
fields are named CountLo and CountHi and contain numbers between 0 and 12.
I want to color some boxes on a subform based on the numbers in Lo and Hi.
I've built a parent form and subform in which the subform records display as
continuous forms. I chose 'continuous forms' because I want to see several
child records at one time. The subform has 13 boxes named box0 ... to ...
box12. I want all the boxes to be white except for the boxes representing
the range from Lo to Hi. For example, if countLo is 3 and countHi is 8, I
want box3, box4, box5, box6, box7, and box8 to be yellow.
It would be easy if I could change the colors each time I change a value,
but how do I simply display the correct colors for data that was previously
entered? I've tried the Open event and a few others, but these events don't
seem to trigger with each occurance of continuous child records. They fire
once when the parent form loads, but they aren't triggered after that.
thanks for your help.