Combo Box showing Blank Values

[glen]

Hello,


I have one combo box bounded with two fields, Id and Description through a query.
I entered a new id in bonded table but for some reason I don't want to enter description now.
And if I delete the entered id then I will loss that unique id which is using for description, which I don't want.
Now the problem is one blank space showing in my combo box.
So what criteria I should use in query criteria to avoid blank spaces?
Thanks.

[Rod]

... WHERE Nz(Description,"") <> "" ...

[glen]

Thanks for your reply.
I put in "Description" field criteria.
WHERE Nz(Description,"") <> ""
But it give Syntax error message.
"You may have entered an operand without an operator"

[alansidman]

Post your SQL statement for the combo box so that we can analyze properly and not guess at an answer.

[glen]

Select department.deptid, department.department
from department;

[glen]

SELECT DEPARTMENT.DEPTID, DEPARTMENT.DEPARTMENT
FROM DEPARTMENT
WHERE Nz(DEPARTMENT,"") <> "";
Solved Thanks.