Null Values in Combo 2

[SeadnaS]

Need a way to stop my combobox from displaying null values.

 

[sxschech]

change record source of combobox to a select statement:

Select * from yoursource where displayvalue is not null;

Yoursource being the name of the table or query
Displayvalue being the field you want to not display null values

 

[SeadnaS]

Oh wait. Not working. Got a popup box with "Getting enter parameter value display value".

 

[sxschech]

Are you able to run the record source as a standalone query, or does it too give an error message?


Is the actual source of the data from a table or a query. If a query is it possible to provide the record source of both the combobox and the query?

 

[PHV]

stop my combobox from displaying null values
What is the SQL code of your combo's RowSource ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SeadnaS]

SELECT DISTINCT T_MASTER.Class FROM T_MASTER;

 

[SeadnaS]

When i add "where displayvalue is not null" thats when i get the problem.

 

[PHV]

SELECT DISTINCT Class FROM T_MASTER WHERE Class IS NOT NULL

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SeadnaS]

SELECT DISTINCT T_MASTER.Class FROM T_MASTER where Class is not null;

I tried that, its does not give me an error message but it still shows empty values.

 

[PHV]

SELECT DISTINCT Class FROM T_MASTER WHERE Trim(Class & '')<>''

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SeadnaS]

Syntax error

 

[PHV]

Syntax error
Copy'n'paste YOUR SQL code.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SeadnaS]

SELECT DISTINCT Class FROM T_MASTER WHERE Trim(Class & '')<>''

thats the code u gave me.

 

[PHV]

And this ?

SELECT DISTINCT T_MASTER.Class FROM T_MASTER WHERE Trim(T_MASTER.Class & "")<>""

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SeadnaS]

Works perfectly! Thanks PHV!