Empty fields in combo box

[Paul B.]

Can someone point me in the right direction to solve this
problem.

I have an unbound combo box in which the database has some
empty rows. I do not want those empty rows to appear in
the drop down list of my combo box.

Thanks!

 

[Rick B]

What is the combo box source? Is the source a query? Filter that source to
exclude blanks.

Rick B


Can someone point me in the right direction to solve this
problem.

I have an unbound combo box in which the database has some
empty rows. I do not want those empty rows to appear in
the drop down list of my combo box.

Thanks!

 

[Paul B.]

The source is a row (OtherFile#) in a table (Requests).
Since there is no requirement for entry of this field, it
is often blank upon entry.

How does one filter a source for a combo box to exclude
blanks?

Cheers

 

[Rick B]

Replace the row source with something like:

SELECT Requests.OtherFile# FROM RequestsWHERE (((Requests.OtherFile#) Is Not
Null));


I'm not sure if it will like that "#" sign in the field name. I try not to
use special characters in mine.



Rick B




The source is a row (OtherFile#) in a table (Requests).
Since there is no requirement for entry of this field, it
is often blank upon entry.

How does one filter a source for a combo box to exclude
blanks?

Cheers

 

[Paul B]

You're right, doesn't like the # in my record name. Lesson
learned.

Cheers

 

[???]

You're right, doesn't like the # in my record name. Lesson
learned.

Cheers

 

[???]

You're right, doesn't like the # in my record name. Lesson
learned.

Cheers

 

[¹Ú¹®¼ö]