Combo Box Dropdown List Query

[Bob]

--
Is it possible to always have a blank row at the top of your dropdown list ,
to be able to select a blank, my list does have "Is Not Null"
Thanks for any help....Bob





..........Jenny Vance

 

[Van T. Dinh]

You can use the same technique to add the "(All)" row in a ComboBox:

http://www.mvps.org/access/forms/frm0043.htm

 

[Bob]

My Row source is:
QrySpellingList
this is the query:
SELECT DISTINCT qrySpelling.Spelling
FROM qrySpelling
WHERE (((qrySpelling.Spelling) Is Not Null));
So where would I add "(All)"
Thanks for any help..Bob

 

[Bob]

Ah ha, I got it, take away "Is Not null" because I have Unique values I just
get one blank, thanks bob