ComboBox show text value and query result ?

[Nyanko]

Hi,

I wonder if this is possible...

I have a combo box to select a list of years generated by a query. Can I add the value ALL into the list ?

Example :
ALL
2016
2015
2014
2013
etc...

I have "ALL" set to the default value and it appears selectable as long as the dropdown isn't selected as it isn't in the list. Can it be included in the list ?

 

[cyanidem]

It can be, but you need to change row source to something like this (assuming your original source was YourQuery and year field was sYear):

SELECT YourQuery.sYear FROM YourQuery UNION SELECT '(All)' FROM YourQuery;

 

[Nyanko]

Ahh I see !
Thank you