[AccessD] Show description of non active item inlistbox/combobox

I purposely left it vague because it seems as thought this is not a
problem that would only apply to my own example.  

I thought the problem was clear, but maybe it is only because it is
mine.

Ok, to clarify.. 
My situation is as follows.. Parent Form, and SubForm.
Parent form has Employee information, and subform contains Training
history.
Subform is shown as continuous form.  When a training record is shown
that does not have an active instructor there is no name listed at all.
So what would be ideal is to have by default the rowsource = to Select
statement without any criteria.  However during the selection process,
have the rowsource = to Select statement where Active = Y, then when the
selection process is complete it will return to the default rowsource.

Does that put it in perspective?  
Sorry about the general question, I really didn't think this one needed
any details.. 

Rich

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William
Hindman
Sent: Wednesday, June 21, 2006 10:43 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Show description of non active item
inlistbox/combobox

...your description is lacking in sufficient detail to address directly
...you only describe one form requirement but two combo requirements
that conflict ...a better description would help ...but there are at
least two approaches that may help you now ...first, you could just add
the Y/N field to the combo box display ...or second, you could leave the
combo box record source empty and change the record source from code as
the situation required ...hth :)

William

----- Original Message -----
From: "Lavsa, Rich" <Rich_Lavsa at pghcorning.com>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>; <ACCESS-L at PEACH.EASE.LSOFT.COM>
Sent: Wednesday, June 21, 2006 10:18 AM
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