[AccessD] Empty Field Label

I remember, using a UNION query of the bound table and a something like '*' 
or 'All' to select or deselect a filter.
Dont remember which db it was, and how exactly I did it.

Lembit

----- Original Message ----- 
From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Friday, April 10, 2009 11:25 PM
Subject: Re: [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?
>>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com