By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,500 Members | 830 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,500 IT Pros & Developers. It's quick & easy.

How do you handle this combo box problem? Do you have a method?

P: n/a
On you form you have a combo box of a list of employees. In the
Employee table you have the employee name, employee id, and an
ActiveInactive status.

Initially, the list contains the names of all employees and may be a
small list. As time goes on some move on, new employees are added and
the list grows longer.

Well, we could trim the list simply by removing those that are now
inactive. A simple solution...but unworkable. Why? Because if you
look at records from the past that contain the inactive employee, the
employee name does not display in to combo.

A possible solution is to change the row source to only show active
employees if the record is new and for records that are old (saved once)
to show all that are active or the employeed that matches the employee
id of the current record.

Is that how you do it? Is there a better method?

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Thu, 29 Jan 2004 03:55:26 GMT, Salad wrote:
On you form you have a combo box of a list of employees. In the
Employee table you have the employee name, employee id, and an
ActiveInactive status.

Initially, the list contains the names of all employees and may be a
small list. As time goes on some move on, new employees are added and
the list grows longer.

Well, we could trim the list simply by removing those that are now
inactive. A simple solution...but unworkable. Why? Because if you
look at records from the past that contain the inactive employee, the
employee name does not display in to combo.

A possible solution is to change the row source to only show active
employees if the record is new and for records that are old (saved once)
to show all that are active or the employeed that matches the employee
id of the current record.

Is that how you do it? Is there a better method?


If you are wanting to be able to change the list source at random during
runtime, then an option group beside the combo box may be the simplest.
Apply a different query to the combo rowsource for each option that is
selected, and requery.

--
Mike Storr
veraccess.com
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.