Link to home
Create AccountLog in
Avatar of Patrick O'Dea
Patrick O'DeaFlag for Ireland

asked on

Color Coding "Customer Merit"

All,

Example.

I have 1,000 customers in my access database.
Each customer is assigned a "Customer Merit" such as "Good", "Bad", "Very Good".

There can be up 50 (!) "Customer Merit" categories and I want to offer my user the facility to color code them.

Therefore, before I setup any customers , I will need very simple maintenance program which has two fields;

[Customer Merit Category] : Good
[Color                                ] : ?????????


I am struggling with the second bit where the questions marks are.

I need to offer the user a dropdown of colors to choose from. How do I program this?

I do not need a 100% solution just a good pointer as to how I start.
SOLUTION
Avatar of Gozreh
Gozreh
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
ASKER CERTIFIED SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Patrick O'Dea

ASKER

THx