Avoiding blank choices in a Combo Box

[Lou_Reed]

What is the option is Combo Box queries that does not permit a blank space as a choice/ Right now I am getting a drop menu on the combo box and at the top of all the names



is simply a blank white space. How can turn that off an just get only choices? No blanks.


Respectfully,


Lou Reed

[June7]

That is caused by a blank record in source. Add filter criteria to the RowSource sql: Not [fieldname] Is Null.

[Lou_Reed]

This statement " RowSource sql: Not [fieldname] Is Null " goes in the record source for the form that has the combo box control?

I just need to know where to put it.

Respectfully,


Lou Reed

[June7]

It would be filter criteria (WHERE clause) in the SQL statement or query used by the RowSource. What is currently referenced in the RowSource property? Post the SQL statement if you need more help.

Otherwise, don't allow 'blanks', make the field Required in table design so there is always a value.

[Lou_Reed]

Okay, I will put it there. Thanks for your help.

Respectfully,

Lou Reed