A
andy mac
Guest
Please can someone help me! I have a subform which contains multiple records. One of the fields in the records is called "Status" & the user will input one of three things in this field. These will be 'swapout', 'rts' or blank. I need each record to have a certain colour, depending on the data in the 'swapout' field. For example, if they enter 'swapout', the record will be yellow; if they enter 'rts' the record will be red & if it is blank, the record will be white. The problem I am having is that when i enter one of these three, not only does that record change colour, but ALL the records change to that colour. If anyone has any ideas @ all, I will be very very grateful.