change back colour with values from a table

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top