Combo Box Dropdown List Query

  • Thread starter Thread starter Bob
  • Start date Start date
B

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
 
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
 
Ah ha, I got it, take away "Is Not null" because I have Unique values I just
get one blank, thanks bob
 
Back
Top