Exclude Value in Row number two from Combobox

[Bongobob21]

Hi,

I want to use a Combobox for selcting a search criteria. It should pull all distinct values from a ceratin column, but not the value which is written in the second row. This that possible?
Currently I am using this code as the row source: SELECT DISTINCT [Table1].Name FROM [Table1];



I need the second row in the table as a orentation for something else but it shouldn"t be displayed in the selection for the combobox.

thanks!

[pbaldy]

You can add

WHERE [Name] <> "Whatever"

[Bongobob21]

Great! Works perfectly

[pbaldy]

Happy to help!