[AccessD] combo box not displaying data

Do your queries have any date dependency?  The only thing different today is
the date!

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Carolyn Johnson
Sent: Wednesday, March 18, 2009 10:40 AM
To: Access Developers
Subject: [AccessD] combo box not displaying data

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