Combo Box empty rows filtering

[rghaddad@inco.com.lb]

Good Morning,
Just Created a Form with a Combo Box.
The combo box lists all the companies in the table. nonetheless, not all record contain a company name.
is there a way to get rid of the empty spaces?
Thanks in advance
Roland

 

[Ranman256]

how can a company not have a name?
either:
filter the query to not show unnamed companies
select coName from tCo where [CoName]<>""

or
have the combo box show 2 or more columns to see fields if there is no Co name
[ID], [CoName],[Address]

 

[GinaWhipp]

Um, if they don't have a name how are they in the database? Or are you saying sometimes it's a person so while the company name is blank there are other fields to identify the entity?

 

[rghaddad@inco.com.lb]

Some people work in a company, some are on their own.

 

[arnelgp]

you can at least but some meaningful data, ie:

"Mr.Arnelgp (Self-Employed)"

 

[MajP]

I am guessing maybe you are trying to get a discrete list of companies already in the DB

"Select Distinct CompanyName from sometable where CompanyName is Not Null"
then your list is
5Index
Quest4
Ejaco
Resco