Combo Box Question

[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

 

[Guest]

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

 

[Van T. Dinh]

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.