[AccessD] Empty Field Label

You will not be able to display a matching value for Null fields in a combobox.

Remembet that the combobox displays the value from its recordset which is *equal to* the 
*value* in the underlying field.  Effectively you are asking the combobox to display 
"ClientID" where [ClientID] = Null

Remember also that (regardless of what Drew thinks <g>),  Null is not a *value* and that 
nothing is *equal to* Null, not even another Null, so  nothing will be displayed for a Null field.
 
You could possibly cheat and set the Default value of [ClientID] to 0, but storing ) where a 
thClientID hasn't been set destroys referential integrity  for a start and can cause other 
problems.as well.



On 10 Apr 2009 at 13:01, Rocky Smolin wrote:

> Thanks Gustav.  Works perfectly in the query.  
> 
> But records without a client ID selected don't show "Client ID" in the combo
> box.  I changed the "0" to Null in the Union query on the theory that those
> record have a null in the record. But no soap.  DO you know why that "Client
> ID" might not be showing up in the combo box?
>