Combo Box Question

  • Thread starter Thread starter Anatoly Kurilin
  • Start date Start date
A

Anatoly Kurilin

Hi, I got no problem with inserting an additional item into the Row Source
of an combo box, for instance:
SELECT tblProject.ProjectID, tblProject.ProjectName FROM tblProject UNION
SELECT "0", "<ALL>" from tblProject ORDER BY tblProject.ProjectName;

But I need to insert Null, not 0. If i do it in the way:
SELECT tblProject.ProjectID, tblProject.ProjectName FROM tblProject UNION
SELECT Null, "<ALL>" from tblProject ORDER BY tblProject.ProjectName;
the combo box contains <ALL> in the list, but after choosing it there's no
"<ALL>" in the combo box left.

A. Kurilin
 
I don't think you can associate Null with "<ALL>" in this case since if the
ComboBox has Null value, this means that it is *unassigned*, i.e. no "row"
selected, and therefore the visible Text component of the ComboBox is blank.
 
Back
Top