Command Board – Fire Dept — 3

– Have a form with twenty-five listboxes. I am able to slide names from listbox to listbox depending on what sector they’re working in.

– I would like that form to be linked to my attendance form. If a name is in certain listboxes they’re automatically checked off as “On-Scene”, and if they’re in other boxes they’re marked off as “At Station”

– Looking for a way to have different colours of text based on another column. If “Firefighter” is from Station 1 their name is Red, Station 2 Blue, and Station 3 Green

I have shaded out my firefighters names