[AccessD] combo box not displaying data -- SOLVED

Thanks Max!

Well - Carolyn had a well-described list of what she'd already tried, so
that was all I could think of!

Dan

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

Good catch, Dan.   Well spotted.

Max


On 3/18/09, Carolyn Johnson <cjlabs at worldnet.att.net> wrote:
>
> Sorry.   The rowsource for the combo box (while shown in the combo box
> properties) is actually determined on the Form Open property and does have
> a
> date dependency -- in this backend's case, today.    That's the SQL that's
> messed up -- the one for today in the code.    I need to put a reminder in
> that the rowsource is in the code, although you wouldn't think I would
> forget after the past 2 hours of panic.
>
>
> Thanks for everyone's help.   I guess it had to be this simple since it
> wasn't making sense.
>
>
> 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
>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com