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

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