Add an entry to a ComboBox

[XP]

I have an unbound combobox on a form. The row source is a "Select" query
against a table and this works fine; however, I also need an additional
choice in the list for the box called "All Colors".

Currently my query reads something like: SELECT DISTINCT Color FROM
tblColors;"
and this returns: Red; Green; Orange; Blue.

I want the list to appear like: ALL COLORS; Red; Green; Orange; Blue.

Please advise as to how I can accomplish this. Should I restructure my SQL?
Should I use VBA to add the extra item?

Please post example SQL and/or example VBA that will do this, and thanks much.

 

[XP]

Sorry, please excuse this post. I got it to work, I just had an error in my
VBA.