[AccessD] combo box not displaying data

I hadn't had it open in design view between the time it was working and the 
time it stopped.   I've had it opened in design view a lot since then  :>

Carolyn




----- Original Message ----- 
From: "Max Wanadoo" <max.wanadoo at gmail.com>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Wednesday, March 18, 2009 10:48 AM
Subject: Re: [AccessD] combo box not displaying data


> Carolyn, Have you had the form open in design mode? If so, just check that
> you haven't changed any of the combos options.
>
> Max
>
>
> On Wed, Mar 18, 2009 at 3:40 PM, Carolyn Johnson 
> <cjlabs at worldnet.att.net>wrote:
>
>> Access2000/2003, Win XP
>>
>> I have a combo box with a union query as a row source.  There are two
>> criteria based on data from other fields.  The combo box was working 
>> great
>> as of last night.  This morning, it will not show the data -- it's 
>> showing
>> no rows.   I've made no changes to the database since the last time I put
>> in
>> new data using this combo box.
>>
>>
>> The union query itself works fine -- I pasted the sql into a new query 
>> and
>> it shows the correct data.   Each half of the union query works fine.
>>
>> The combo box works fine with a different backend, but not the one I need
>> to
>> use now.
>>
>>  I did a compact and repair on the "bad" backend -- no change.
>>
>> I've deleted the links to the tables and relinked the backend -- no 
>> change.
>>
>> I've imported all the tables into a new mdb -- no change.
>>
>> I've taken the tables from the "working" version that are common to both
>> and
>> the specific tables from the "bad" backend and combined them into a new
>> mdb -- no change.
>>
>> I've tried using Access2003 -- no change.
>>
>> None of the records in the backend looks screwed up.
>>
>>
>> I'm afraid my only option now is to create a new backend from the version
>> that works and re-enter all the data.
>>
>> Does anyone have any other suggestion?
>>
>>
>> Thanks
>> Carolyn Johnson
>> St Louis, MO
>>
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com