Coloured boxes

  • Thread starter Thread starter Matt Borrill
  • Start date Start date
M

Matt Borrill

Probably a very simple way of doing this but, I want a box
to change colour on a form dependent on what value is
entered into another field. Now on a single form this is
very easy using the If statement, however on continuous
forms if one record has this value all of the boxes change
colour. I want each record on the form to behave
independently so that I can have a display of "status"
boxes according to the field on each individual record.
Hence when a user reads down the records they can see from
the colours the state of each record.

If that makes sense I would appreciate any help
cheers

Matt
 
Back
Top