Rocky Smolin at Beach Access Software
rockysmolin at bchacc.com
Wed Mar 18 11:26:28 CDT 2009
I would guess that there's something about one of the data fields that's hosed. Except you say "The combo box works fine with a different backend, but not the one I need to use now." but the union query shows the data on the 'bad' back end and the combo box does not, yes? WAG - have you checked the table links in the database container? 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:07 AM To: Access Developers discussion and problem solving Subject: Re: [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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com