[AccessD] Need help with a combobox issue

Joe:

I would put a checkbox on the form labeled "Show Inactive Employees".  Set 
it default to false and leave the record source of the combo box as it is 
now withthe inactives not shown.

In the after update event of the check box change the record source of the 
combo box to show or suppress the Inactives depending on the current value 
of the check box and don't forget to requery the combo box after you change 
the record source.

HTH

Rocky Smolin
Beach Access Software
http://www.e-z-mrp.com
858-259-4334

----- Original Message ----- 
From: "Joe Rojas" <JRojas at tnco-inc.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Monday, January 17, 2005 10:12 AM
Subject: [AccessD] Need help with a combobox issue


> Hi All,
>
> I have a combobox that is bound to a field. The field stores the employee
> number that is associated with the current record. The data for the 
> combobox
> is pulled from a table and the combobox is set to limit to list. The list 
> is
> made up of two columns, one for the employee number (bound column) and
> another to display the employee's name. The employee number column is set 
> to
> 0" so that only the employees name is visible. Because employees come and
> go, I have added the ability to edit which employees are shown in the
> combobox list. This allows the addition and removal of new and old 
> employees
> respectively.
>
> At the time a record is created the associated employee would have been in
> the combobox list because they would be an active employee. Some time 
> after
> the creation of this record the employee may leave the company and would 
> be
> remove from the list of the combobox but the record would still reference
> the terminated employee. If someone were to go back and look at this 
> record,
> it would display nothing because the employee is not in the list. I added
> some code that checks to see if the Text property of the combobox is an
> empty string and if so look up the name of the terminated employee and set
> the combobox's Text property accordingly. The problem with this is that it
> generates a NotInList error and you are forced to undo the change in order
> to move on.
>
> Any ideas on how to work around this. I would like to keep the ability to
> modify the list of active employees so that users do not waste time 
> weeding
> through old employees while allowing the combobox to display the employee
> name of someone who is no longer with the company.
>
> Any help will be greatly appreciated!
>
> Thanks
> JR
>
>
>
> This electronic transmission is strictly confidential to TNCO, Inc. and
> intended solely for the addressee. It may contain information which is
> covered by legal, professional, or other privileges. If you are not the
> intended addressee, or someone authorized by the intended addressee to
> receive transmissions on behalf of the addressee, you must not retain,
> disclose in any form, copy, or take any action in reliance on this
> transmission. If you have received this transmission in error, please 
> notify
> the sender as soon as possible and destroy this message. While TNCO, Inc.
> uses virus protection, the recipient should check this email and any
> attachments for the presence of viruses. TNCO, Inc. accepts no liability 
> for
> any damage caused by any virus transmitted by this email.
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>