Run code for each record

[echorley]

I have a report that will "bubble" in a student's student ID number on a test scan sheet.

For example, if the ID number is 381, then the code I have written will shade in (make the backcolor of a textbox black)the number 3 bubble in the first column, the number 8 bubble in the second column and finally the number 1 bubble in the 3rd column.

When I run this code in the Report Load event, it only works for the first record. While the other student numbers show up on subsequent pages, the backcolor keeps repeating itself.

How do I get the code I wrote to apply to each individual student record?

 

[pbaldy]

Try it in the detail format event instead.

 

[echorley]

Thanks! That was it.