[AccessD] Show description of non active item in listbox/combobox

Could you have the combo show ALL...display name and active field...just for 
display...then use a dlookup after the update to NOT let them select the 
inactive?  Not sure exactly what you want to display/select?

Hope that helps???

Mark A. Matte


>From: paul.hartland at fsmail.net
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>Subject: Re: [AccessD] Show description of non active item in 
>listbox/combobox
>Date: Wed, 21 Jun 2006 16:32:09 +0200 (CEST)
>
>Just a quick reply, couldn't you have the one combo/list box with a check 
>box next to it saying inactive, when you first go into the form the 
>combo/list box will only display the active ones, if you click the check 
>box, change the query the combo/list box looks at to display either active 
>and inactive or just the inactive ones, when the check box is unchecked 
>just display the active ones.  There is probably a better way to do such a 
>thing, but I have used this method in the past with no problems.
>
>
>
>
>
>Message Received: Jun 21 2006, 03:26 PM
>From: "Lavsa, Rich"
>To: "Access Developers discussion and problem solving" , 
>ACCESS-L at PEACH.EASE.LSOFT.COM
>Cc:
>Subject: [AccessD] Show description of non active item in listbox/combobox
>
>Hello all,
>
>I have an application where I created for example a table that holds
>names and some details of instructors. I also have an Active field Y or
>N. The combobox will only display instructors who are marked with Y.
>Yet this will allow you to maintain all your reporting for historical
>data.
>
>The issue that comes into play when in the entry form, for a particular
>employee that took training, in looking at the detail records of their
>training, if they happened to take a class/session that was taught by an
>instructor that isn't active any longer there isn't any Name displayed
>in the form because the combobox will not retrieve this information.
>
>Does anyone have a solution for this?
>
>I in the past I have put 2 combobox's side by side and shrunk the one
>down so that only the button is displayed which is then placed directly
>over the full size combobox button. The shrunken button has the
>criteria in it to only retrieve the Y's, however the full size combo can
>retrieve everything, so on the screen everything looks ok and seems to
>function ok. This approach doubles the combobox's, and doubles the
>maintenance if anything changes in the lookup tables.
>
>Hoping someone has a better way to handle this situation.
>
>Thanks in advance for any tips/tricks/ideas...
>
>Rich
>--
>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