Hi,
I'm wondering if it's possible "manually" add an extra value to a combobox list.
At the moment I have two fields, one "transparent" is a checkbox that lets you define a colour as transparent, and the other is a combobox called "Colours" that lists colours.
The values in Colours depend on two differnet querys each based on tblColour. the query qTransparentColours shows all colours where the field Transparent is true and qSolidColours shows all colours where the field Transparent is false.
Now what I want to do is add a menu item to the combobox Colours on my form called "All" independent of the tblColour table.
As you have propably figured out I use the values of this combobox Colours for further functionality. And the reason why I want my tblColour to be intact is that I use the values of it at another place in my application.
So what I want to have as results would be something like:
Transparent: All, Blue, Green Red
Solid: All, White, Yellow, Black
Where at the moment it only shows
Transparent: Blue, Green, Red
Solid: White, Yellow, Black
I did consider doing it by changing the Rowsource of the combobox instead of running a query, but that didn't seem very flexible compared to using the query-solution.