M
Mohan
Hi
I have created a simple project tracking application. The user can flag the
prject with 'Red', 'Yello' , or 'Green' . (or other colours in future)
Currenlty I am using a table with the following three values 'RED', 'YELLOW'
and 'GREEN' and depending on the selection, I change the back colour of the
control to red, yellow or green using vbRed, vbYello and vbGreen.
The problem is, users wan't to be able to add new status and a corresponding
colour in future. How can I store the values (RBG co-ordinates) in the same
table and use that to change the backcolour of the control instead of using
vbRed, vbYellow and vbGreen
Thanks
Mohan
I have created a simple project tracking application. The user can flag the
prject with 'Red', 'Yello' , or 'Green' . (or other colours in future)
Currenlty I am using a table with the following three values 'RED', 'YELLOW'
and 'GREEN' and depending on the selection, I change the back colour of the
control to red, yellow or green using vbRed, vbYello and vbGreen.
The problem is, users wan't to be able to add new status and a corresponding
colour in future. How can I store the values (RBG co-ordinates) in the same
table and use that to change the backcolour of the control instead of using
vbRed, vbYellow and vbGreen
Thanks
Mohan