I think this has a simple answer.
Situation:
I have a table that has individual values: Blue;Green;Red;Orange; and I use this table in several locations in my program, including a combobox which you could choose one of those values.
What I want:
I also want to be able to select an ALL option in the combo box.
Problems:
I dont want to add ALL to the original table because that will ruin it where it is used in other parts of the program.
I also dont want to put in a straight value list because the combobox is then not transferable to other situations.
Possible solutions:
1 - make a query that will list all the values I want and also add to that list another value of "ALL" (I dont know how to do this)
2 - Use an SQL statement in the RowSource that will use "ALL" then the values from a given table. (I dont know how to do this)
Any help is appreciated, thanks.