[AccessD] combo box not displaying data

Rocky Smolin at Beach Access Software rockysmolin at bchacc.com
Wed Mar 18 11:27:58 CDT 2009


Would it be quick to recreate the combo box on the theory that something is
changed/hosed with that control and see if the new one works side by side
with the old one that doesn't.  I've done this a couple times and been
surprised.


Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com
www.bchacc.com
 
 

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

No dates.


I can't figure it out.    Since the front end works with the other version 
of the backend, it would seem to be a backend problem.    But the rowsource 
saved as a query works with the backend, so that suggests something in the
form / combo box.

When I use the saved query as the rowsource, I get nothing displayed.    But

if I open the rowsource, I do get the data.

This combo is dependent on a text box on a parent form and another combo box
on the same form.  When the other combo box is updated, the problem combo 
box is requeried.   I've checked that the names of the text box and other 
combo box are correct in the query.


Carolyn



----- Original Message ----- 
From: "Dan Waters" <dwaters at usinternet.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Wednesday, March 18, 2009 10:47 AM
Subject: Re: [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
>
>
> -- 
> 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




More information about the AccessD mailing list