J
James Frater
Hello All,
I have a continuous form which shows all records over a period of time (day,
month, year) for all the locations we work at. To make navigation easier
through this form I'd like to add in a unbound rectangle that changes it's
backcolour to match the location colour of the record.
Stepping backwards a little bit, for each of the 23 locations we have a
different colour. The colour is kept in number format.
So, I'd like the form to look a little bit like this
Location Box Colour
Lawns 1580217
Rugby1 7619088
Football4 1507468
Rugby1 7619088
Clubhouse 7697781
I've tried differnet bits of code (me.boxLocation.backcolor =
me.locationcolour) in differnet places (on_current) but none of them seem to
work.
Any thoughts or help would be greatly appreciated.
Many thanks
JAMES
I have a continuous form which shows all records over a period of time (day,
month, year) for all the locations we work at. To make navigation easier
through this form I'd like to add in a unbound rectangle that changes it's
backcolour to match the location colour of the record.
Stepping backwards a little bit, for each of the 23 locations we have a
different colour. The colour is kept in number format.
So, I'd like the form to look a little bit like this
Location Box Colour
Lawns 1580217
Rugby1 7619088
Football4 1507468
Rugby1 7619088
Clubhouse 7697781
I've tried differnet bits of code (me.boxLocation.backcolor =
me.locationcolour) in differnet places (on_current) but none of them seem to
work.
Any thoughts or help would be greatly appreciated.
Many thanks
JAMES